<!-- https://learnsql.cpetoday.com/functions/dax/totalmtd -->
# TOTALMTD

Language: DAX
Category: Time intelligence: to date
Syntax: TOTALMTD(<expression>, <dates> [, <filter>])
Summary: Evaluates an expression from the first day of the month up to the last date in the filter context.
Returns: A value (a scalar).
Level: Beginner
Related: DATESMTD, TOTALQTD, TOTALYTD, CALCULATE, MONTH

## 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.

```dax
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.

```dax
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.
