Tag Archives: DAX

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

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

Customer Churn

A common business request is to report on Customer Churn, that is to show the movement in customers from one period to the next. To do this with Excel involves massive data loads and complex formula that need to be … Continue reading

Posted in Power Pivot | Tagged , , | 2 Comments