11. Using DAX for Date Magic
In This Chapter
Using Time Intelligence Functions 242
Using Date Functions for Data Reported at a Monthly Level 248
Be honest. Did you really read Chapter 10, “Using DAX for Aggregate Functions,” or did you skip it?
If you skipped it, let me offer a recap for you:
=CALCULATE(Sum(Sls[Sales]), Filter 1, Filter 2, ...)
This calculated field will calculate the total sales for all rows that match the filters specified. If one of the filters specified in the CALCULATE function is for a dimension already in the pivot table, the filter in CALCULATE will override the filter in the pivot table.
Most of the time intelligence functions are designed to be used as the filter in ...
Get PowerPivot for the Data Analyst: Microsoft® Excel 2010 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
