July 2018
Beginner
202 pages
5h 4m
English
A lot of time series analysis consists of comparing current metrics to the previous month or previous year. There are many functions in DAX that work in conjunction with the CALCULATE function to make these types of calculations easy. You are going to create a new measure to return the total sales for the prior year.
Create a new calculated measure on your Internet Sales table using the following DAX formula:

CALCULATE allows you to ignore or even change the current filter context. In the preceding formula, CALCULATE is used to take the current filter context ...
Read now
Unlock full access