Downloads
DAXTime intelligence: to dateIntermediate

TOTALQTD

Evaluates an expression from the start of the calendar quarter up to the last date in the filter context.

Syntax
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

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

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.

Related functions

All DAX functions · View as Markdown · DAX fundamentals