11. Using DAX for Date Magic

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 now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.