Some time ago, I wrote a post about how to handle Parent/Child hierarchies in PowerPivot 1.0. It was pretty intricate, because P/C are not handled natively in PowerPivot. Now, with the advent of Denali, Microsoft gave us all the functions needed to handle  Read more

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

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

While it is well know that in UDM data should be loaded sorted, to get better file compression and map structures. The world of PowerPivot (and BISM) is yet not explored. Working with a 50 millions rows table, I tested various scenarios to check if sorting  Read more

I teach to my students always to remove all useless columns from PowerPivot data models, because they simply waste precious memory. While I was working on a test model with 50 millions of rows, I did the naive mistake of loading the complete table in  Read more

Yep… it’s me. :)  Read more

In case you missed it, this post from Jeffrey about DAX and the way filter contexts work is simply awesome! The way he explains the filter contexts internals is great, deep technical and yet easy to understand. Very very strongly suggested as a good reading  Read more

As you might already know I have written an add-in for Microsoft Visio 2010 which makes it able to forward engineer database diagrams to SQL Server. A huge number of people downloaded it and started asking for some new features, as it is always the case  Read more

One of my readers came to me with an interesting formula to compute in PowerPivot. Even if I don’t normally post about very specific scenarios, I think this time it is interesting to write a blog post since the formula can be easily created, if you think  Read more

Following my last post about parent/child hierarchies in PowerPivot, I worked a bit more to implement a very useful feature of Parent/Child hierarchies in SSAS which is obviously missing in PowerPivot, i.e. unary operators. A unary operator is simply  Read more