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.