December 2018
Beginner to intermediate
794 pages
19h 29m
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