Practical Powerpivot & Dax Formulas For Excel 〈Limited Time〉

DATEADD : Used for time intelligence, such as calculating "Year-Over-Year" growth by shifting dates.

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: Practical PowerPivot & DAX Formulas for Excel

CALCULATE : The most powerful function, used to modify the filter context of a calculation. DATEADD : Used for time intelligence, such as