SUMX : An "iterator" function that performs a calculation row-by-row before summing the results.
: 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
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: SUMX : An "iterator" function that performs a
: It bridges the gap between different data worlds, including appendixes for SQL, MDX, and DMX query design. including appendixes for SQL
DATEADD : Used for time intelligence, such as calculating "Year-Over-Year" growth by shifting dates.
: The book includes simplified chapters designed to help users build sophisticated pivot tables in just a few minutes. Essential DAX Formulas for Power Users