TOTALMTD
Evaluates an expression from the first day of the month up to the last date in the filter context.
TOTALMTD(<expression>, <dates> [, <filter>])Returns: A value (a scalar).
What it does
TOTALMTD gives a running total for the current month. Finance teams use it for flash reports, mid-month cash positions and expense tracking during a close. It starts again on the first day of each month. Comparing month to date with the same days of the prior month is a common way to read a partial month fairly.
Syntax and arguments
- expression: the measure to total, such as [Total Revenue]. Required.
- dates: the date column of the Calendar table. Required.
- filter: an optional filter, such as 'Sales'[Region] = "East". Optional.
Example
The sales operations team sends a flash report on the 15th of each month. The total for the current month so far is the revenue from the 1st through the report date.
Revenue MTD = TOTALMTD([Total Revenue], 'Calendar'[Date])
On October 15, 2026, the measure adds revenue for October 1 to October 15. Put it on a card with the report date so readers know how many days are in the figure.
Example: a second, different use
A fair comparison for a partial month is the same number of days last month. DATEADD shifts the visible days back one month, and TOTALMTD then totals them from the start of that prior month.
Revenue MTD Prior Month =
CALCULATE([Revenue MTD], DATEADD('Calendar'[Date], -1, MONTH))
If the report date is October 15, the prior-month figure covers September 1 to September 15. The two numbers are a like-for-like comparison.
Things to watch
- TOTALMTD has no year end argument. Months are calendar months.
- A partial month is not comparable with a full prior month. Use the same-days comparison shown above, or the full prior month with PARALLELPERIOD if the question is about the full month.
- Make sure the report date is the last date with data. If the latest day has no data yet, the figure may look lower than it is.
- The Calendar date column must be used, and the Calendar must have no gaps.
In business terms
TOTALMTD runs the mid-month flash, the daily cash position and the in-close expense tracker. It helps the controller see whether the month is on track before the close starts.