03. Time Intelligence
Master date-based calculations like Year-to-Date, comparisons, and moving averages.
TOTALYTD / QTD / MTD
Running totals that automatically reset at the end of a period.
👉
SAMEPERIODLASTYEAR
Compare current sales vs the exact same dates one year ago.
👉
DATEADD
Shift dates forward or backward by custom intervals (Month, Quarter, Year).
👉
DATESINPERIOD
Create a moving window of dates (e.g., Rolling 3 Months Average).
👉
PARALLELPERIOD
Shift to a full period (e.g., compare this month to the *entire* previous year).
👉
CALENDAR / CALENDARAUTO
Generating a contiguous Date Table from scratch.
👉
⬅ Back to DAX Menu