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.
Also called month-to-date.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains MTD in context, with comparison tables and the common traps.
Terms in this definition
- MONTH
A DAX date function giving a date's month as a whole number, where 1 is January and 12 is December.
- 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.
- 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.
- Get
Key Vault permission on secrets that allows a single secret to be read; App Service Key Vault references need nothing beyond it.
- DATESMTD
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.
- TOTALMTD
Works out the running month-to-date figure for a DAX expression, based on dates in a column or, if calendar-based time intelligence is in use, on a calendar.
- 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.