OpenBI Docs Buy

DATESQTD

The dates from the start of the quarter to the last date in the filter context.

Group: Time intelligence. Compatible with DAX.

Syntax

DATESQTD ( <dates> )
ParameterTypeDescription
datesDatesA column of dates of the model, such as Sales[Month], or the name of a calendar defined in the model.

Returns

Table. The column's dates from the start of the quarter to the last date in the filter context.

Remarks

  • The quarter is the calendar quarter of the last date in the filter context.
  • Given a column, it reads the dates visible in the current filter context; in a row context, such as ADDCOLUMNS, the row becomes a filter first, so each row sees its own dates.
  • Used as a filter in CALCULATE, it gives a quarter-to-date figure, as TOTALQTD does.
  • Only dates the column holds come back: a date the move or the period lands on that the column lacks is left out, and when none is left the table is empty.
  • Given a calendar instead of a column, it works on the calendar's own periods (fiscal years, retail months of four or five weeks, ISO weeks). A filter on a category the calendar does not define, such as a month on a calendar of weeks, can make the call an error.

Examples

The months of the quarter so far

EVALUATE
CALCULATETABLE (
    DATESQTD ( Sales[Month] ),
    Sales[Month] = DATE ( 2025, 5, 1 )
)
ORDER BY Sales[Month]
Sales[Month]
2025-04-01
2025-05-01

Business days of the quarter so far

EVALUATE
CALCULATETABLE (
    ROW (
        "Days", COUNTROWS ( DATESQTD ( Prices[Date] ) ),
        "From", MINX ( DATESQTD ( Prices[Date] ), Prices[Date] )
    ),
    Prices[Date] = DATE ( 2026, 8, 14 )
)
DaysFrom
332026-07-01

TOTALQTD, DATESYTD, DATESMTD, STARTOFQUARTER.

Last updated · OpenBI Studio 0.3.74