Downloads
DAXTime intelligence: to dateIntermediate

DATESQTD

Returns a table of dates from the start of the calendar quarter up to the last date in the filter context.

Syntax
DATESQTD(<dates>)

Returns: A table of dates, used as a filter inside CALCULATE.

What it does

DATESQTD returns the dates from the start of the current calendar quarter to the last date in the context. CALCULATE uses those dates as a filter, so any measure can be shown quarter to date. Use it when TOTALQTD is not flexible enough, for example when another filter or a shifted period is needed.

Syntax and arguments

Example

A collections team tracks cash received quarter to date. In a view for November 2026, the filter covers October 1 through the last date in the context.

Cash Received QTD =
CALCULATE(
    SUM('Payments'[Amount]),
    DATESQTD('Calendar'[Date])
)

The total starts on October 1, because October begins the fourth calendar quarter. It resets to zero at the start of January.

Example: a second, different use

The same quarter-to-date days in the prior quarter. DATESQTD gives the current days, and DATEADD moves them back one quarter, so the comparison is like for like.

Revenue QTD Prior Quarter =
CALCULATE(
    [Total Revenue],
    DATEADD(DATESQTD('Calendar'[Date]), -1, QUARTER)
)

When the quarter-to-date days run from October 1 to November 15, the prior-quarter figure covers July 1 to August 15 of the same year.

Things to watch

In business terms

DATESQTD underpins quarter-to-date bookings, cash collections, expense tracking and the quarter-end forecast. It helps a controller or sales leader judge the quarter before it closes.

Related functions

All DAX functions · View as Markdown · DAX fundamentals