For Excel: Practical Powerpivot & Dax Formulas

CALCULATE : The most powerful function, used to modify the filter context of a calculation.

: Practical examples show how to compare current performance against the past and handle tricky calculations like running totals or non-numeric values. Practical PowerPivot & DAX Formulas for Excel

RANKX : Automatically ranks items (like products or sales reps) based on a specific value. Practical PowerPivot & DAX Formulas for Excel 2010 CALCULATE : The most powerful function, used to

DATEADD : Used for time intelligence, such as calculating "Year-Over-Year" growth by shifting dates. Practical PowerPivot & DAX Formulas for Excel 2010

: It contains over 250 downloadable DAX formulas that cover everything from basic filtering to complex statistical and time-intelligence functions.

: It bridges the gap between different data worlds, including appendixes for SQL, MDX, and DMX query design.

In his book author Art Tennick provides a comprehensive guide for extracting actionable insights from massive corporate datasets. This "hands-on" resource is particularly noted for: