Month-to-date measures rely on this DAX time intelligence function, which yields each date between the first of the month and whatever latest date the current context holds.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains DATESMTD in context, with comparison tables and the common traps.
Terms in this definition
- MTD
Month to date: everything from the first of this month until today. In DAX you get it with DATESMTD or TOTALMTD, and calculation groups for time intelligence often include it.
- 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.
- MONTH
A DAX date function giving a date's month as a whole number, where 1 is January and 12 is December.