Time Intelligence Functions
AS
Aman Saurav
10 min read
#dax
#time
Comparing this year to last year is easy with DAX.
Sales LY = CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date]))
Prerequisite
You must have a dedicated Date Table marked as a date table for these functions to work correctly.