Year-to-date measures rely on this DAX time intelligence function. It yields each date from the year's first day up to whatever latest date the current context holds, and accepts an optional year-end date so fiscal years can be handled.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains DATESYTD in context, with comparison tables and the common traps.
Terms in this definition
- YTD
Year to date: totalling from January 1st (or a fiscal year start) up to now, which DAX handles through TOTALYTD or DATESYTD.
- DAX
Short for Data Analysis Expressions, the formula language you write measures, calculated columns and row-level security rules in, within tabular semantic models in Power BI, Excel Power Pivot or Analysis Services.
- Time intelligence
Covers DAX functions (TOTALYTD, DATEADD, SAMEPERIODLASTYEAR and others) that shift or accumulate filtered dates. Classic versions require a contiguous, marked date table; calendar-based versions, still in preview, rely on defined calendars.
- FIRST
A DAX function available only inside visual calculations. It fetches the value at the start of one axis of the visual's matrix, which makes it handy for comparing each point with the first; its opposite is LAST.