PowerBI DAX Time Intelligence Functions

Time Intelligence Functions

AS
Aman Saurav
| Feb 11, 2025 |
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.