DAX Patterns in PowerPivot

Download

Right click “Save as…”

Slides (view online)
DAX (Data Analysis Expressions) is the language for the definition of calculation expressions in PowerPivot for Microsoft Excel. It has syntax similar to Excel, but it also offers a set of functions that are specific to PowerPivot features. This session shows the capabilities of DAX through a wide set of calculation patterns, which are immediately usable -- from simple contribution percentages through to more advanced calculations, like ABC classification (Pareto), time-driven comparison and aggregations, distinct count measures, many-to-many relationships, and much more.

Follow the Discussion

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.