May 2011 - Posts

• PowerPivot, basket analysis and the hidden many to many

  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 Read More... Posted Thursday, May 19, 2011 11:44 PM by AlbertoFerrari | 4 Comments Filed under: BISM, DAX, PowerPivot, Tabular

• PowerPivot: Counting active days

  Browsing on the web I have seen an interesting question that is worth a post, since I think it is a very common pattern and a good example of “thinking in DAX”. Starting from a table which contains a people and two dates (ActiveFrom, ActiveTo), we want Read More... Posted Thursday, May 12, 2011 12:27 AM by AlbertoFerrari | 3 Comments