You are viewing a single comment's thread from:
RE: Easy Excel Solutions: Power Pivot Many to Many Relationships
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 :)
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