Category Archives: Power Pivot

Quench your thirst for knowledge

Like many analysts I’ve always had it in my mind that if I only had some new data to fill in a ‘data jigsaw’ then I’d be able to add much more value to the business. Frequently this information isn’t … Continue reading

Posted in Analytics, Power Pivot | Tagged , | Leave a comment

Rank and STDEV in Power Pivot 2012

I was prompted to write this post based on a question in the SQL forums. There is a single table of data containing thousands of transactions by Customer, Year, Origin, Type.  The measure is Sales. The output needs to show … Continue reading

Posted in Power Pivot | Tagged , | Leave a comment

New Features in PowerPivot v2

PowerPivot v2 for SQL 2012 was released in March.  Some of the limitations we had in v1 of the product have been solved in this v2 release which makes modelling easier and enables the analysis of large items in a … Continue reading

Posted in Power Pivot | Tagged , | 2 Comments

Row Context and EARLIER()

With PowerPivot there is a concept called Row Context.  The Row Context consists of a single row of a table.   Certain DAX functions have an iteration function.  One of these is SUMX().  The SUMX function iterates over the rows … Continue reading

Posted in Power Pivot | Tagged , | 5 Comments

Context is King

If you’re new to Power Pivot (especially if you have an Excel background) it’s very beneficial to study Power Pivot context before trying to learn DAX.  The context provided by Power Pivot enables the creation of dynamic calculations that respond … Continue reading

Posted in Power Pivot | Tagged , | Leave a comment