PowerPivot, basket analysis and the hidden many to many

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

Surfing on the web, here, I came into this intriguing question:

How do we ask something like "Show me how many customers have an iPad but don't have a book?"

We are speaking about a sales analysis where the canonical entities are Customers, Products and Sales. Moreover, because we have been used to speak about cycles since many years ago, due to the nature of AdventureWorks, the question can be posed in AdventureWorks's language as:

Read more...

Tags: dax, many-to-many

 

2007-2015 VidasSoft Systems Inc.