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]))
You must have a dedicated Date Table marked as a date table for these functions to work correctly.