Downloads
DAXTime intelligence: to dateBeginner

TOTALMTD

Evaluates an expression from the first day of the month up to the last date in the filter context.

Syntax
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

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

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.

Related functions

All DAX functions · View as Markdown · DAX fundamentals