TOTALMTD

Evaluates the value of the expression for the month to date, in the current context.

Syntax

TOTALMTD(<expression>,<dates>[,<filter>])

Parameters

TermDefinition
expressionAn expression that returns a scalar value.
datesA column that contains dates.
filter(optional) An expression that specifies a filter to apply to the current context.

Return Value

A scalar value that represents the expression evaluated for the dates in the current month-to-date, given the dates in dates.

Remarks

The dates argument can be any of the following:

  • A reference to a date/time column.
  • A table expression that returns a single column of date/time values.
  • A Boolean expression that defines a single-column table of date/time values.

This DAX function is not supported for use in DirectQuery mode.

Example

The following sample formula creates a measure that calculates the ‘month running total’ or ‘month running sum’ for Internet sales.

=TOTALMTD(SUM(InternetSales_USD[SalesAmount_USD]),DateTime[DateKey])  

See also

ALL function (DAX)
CALCULATE function (DAX)
TOTALYTD function (DAX)
TOTALQTD function (DAX)

***** Related Blog Posts *****
60 Page DAX Formula Reference Guide Download Now Available
Show Only Top Or Bottom Results Using Ranking Formula Techniques – Power BI & DAX

***** Related Video Tutorials *****
Ultimate Beginners Guide to DAX

What Is DAX? & Why Do You Need To Learn It – (1.2) Ultimate Beginner Guide to DAX
Formula Syntax, Comments & Variables – (1.6) Ultimate Beginners Guide to DAX
Examples Of Advanced DAX – (1.18) Ultimate Beginners Guide to DAX

***** Related Course Modules *****
Ultimate Beginners Guide to DAX
Mastering DAX Calculations
Solving Analytical Scenarios w/ Power BI and DAX
DAX Formula Deep Dives
Advanced DAX Combinations

***** Related Support Forum Posts*****
Mastering DAX Calculations: What Is DAX?
Understanding DAX Formula
Developing Complex Dax functions
Data Types And Operators
YTD Showing for Months after Last Sale
Month To Date Comparisons