You are viewing a single comment's thread from:

RE: Easy Excel Solutions: Power Pivot Many to Many Relationships

in #excel5 years ago

Can you make derived tables?

So the join, or foreign key table would be 'date'+'product' - 60 rows if there were 15 dates and 4 products. Dunno, other examples i've seen online use the same approach as you :)

Sort:  

its works in sql and I think with a little DAX magic you could get it to work.

When I was hunting for help I saw DAX mentioned but you know, I got things to do and people to see :P