What is that PowerPivot pivottable context they keep talking about?
One of the most important things you need to know when you work with PowerPivot is Pivottable context. Although this is not so obvious, understanding this helps you in writing DAX functions.
When i was at teched 2010 I attended Ashvini Sharma’s presentation on DAX (which you can see here for free) he had a great way of explaining the context by using dax formula’s. Today i want to show you what PivotTable context is all about using Ashvini’s explanation.