TOTALQTD
Evaluates an expression from the start of the calendar quarter up to the last date in the filter context.
TOTALQTD(<expression>, <dates> [, <filter>])Returns: A value (a scalar).
What it does
TOTALQTD gives a running total for the current quarter. Finance teams use it to track bookings, revenue and collections against a quarterly target while the quarter is still open. The total resets at the start of each calendar quarter, so January, April, July and October each start a new quarter-to-date figure.
Syntax and arguments
- expression: the measure to total, such as [Bookings]. Required.
- dates: the date column of the Calendar table. Required.
- filter: an optional filter, such as 'Sales'[Region] = "West". Optional.
Example
A sales leader tracks bookings against the quarter's target. In a day-level view for October 15, 2026, the total covers October 1 through October 15.
Bookings QTD = TOTALQTD([Bookings], 'Calendar'[Date])
Put this measure next to a quarterly target in the same table. The target is usually a full-quarter number, so the team compares the QTD figure with the share of the quarter that has passed.
Example: a second, different use
Quarter-to-date revenue against the quarterly budget, shown as a variance. Both measures use the same calendar, so the periods line up.
Revenue QTD = TOTALQTD([Total Revenue], 'Calendar'[Date])
Budget QTD = TOTALQTD([Budget Revenue], 'Calendar'[Date])
Variance QTD = [Revenue QTD] - [Budget QTD]
Things to watch
- TOTALQTD has no year end argument. It always uses calendar quarters. For a fiscal quarter, build a filter from the fiscal quarter column in the Calendar.
- The date column must come from the Calendar table, and the table must have no gaps.
- A quarter-to-date number for a closed quarter is the same as the quarter total, so use it in an open-quarter view only if you want the running figure.
- Compare QTD with the same point in the prior quarter, not with the full prior quarter, so the comparison is fair. DATEADD with QUARTER does that.
In business terms
TOTALQTD is used in quarterly sales reviews, bookings tracking, quarterly budget versus actual reports and cash collections meetings. It shows whether the quarter is on track while there is still time to change course.