TOTALMTD Evaluates the value of the expression for the month to date, in the current context.
Expression – An expression that returns a scalar value.
Dates – A column that contains dates.
Filter – (optional) An expression that specifies a filter to apply to the current context.
A scalar value that represents the expression evaluated for the dates in the current month-to-date, given the dates in dates.