: It bridges the gap between different data worlds, including appendixes for SQL, MDX, and DMX query design.
RANKX : Automatically ranks items (like products or sales reps) based on a specific value. Practical PowerPivot & DAX Formulas for Excel 2010 Practical PowerPivot & DAX Formulas for Excel
: The book includes simplified chapters designed to help users build sophisticated pivot tables in just a few minutes. Essential DAX Formulas for Power Users : It bridges the gap between different data
SUMX : An "iterator" function that performs a calculation row-by-row before summing the results. including appendixes for SQL
: Practical examples show how to compare current performance against the past and handle tricky calculations like running totals or non-numeric values.