TOTALQTD Function (DAX)
Evaluates the value of the expression for the dates in the quarter to date, in the current context.
An expression that returns a scalar value.
A column that contains dates.
(optional) An expression that specifies a filter to apply to the current context.
A scalar value that represents the expression evaluated for all dates in the current quarter to date, given the dates in dates.
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.
Constraints on Boolean expressions are described in the topic, CALCULATE Function (DAX).
The following sample formula creates a measure that calculates the 'quarter running total' or 'quarter running sum' for the Internet sales.
To see how this works, create a PivotTable and add the fields, CalendarYear, CalendarQuarter and MonthNumberOfYear, to the Row Labels area of the PivotTable. Then add a measure, named Quarter-to-date Total, using the formula defined in the code section, to the Values area of the PivotTable.