Downloads
DAXTime intelligence: first and lastIntermediate

STARTOFQUARTER

Returns the first date of the calendar quarter that contains the dates in the filter context, as a one-row table.

Syntax
STARTOFQUARTER(<dates>)

Returns: A table with one date, used as a filter inside CALCULATE.

What it does

STARTOFQUARTER returns the first day of the quarter in context. Inside CALCULATE it limits the measure to that day, which is useful for a balance at the start of the quarter. Finance teams use it for the quarter opening position of deferred revenue, receivables and accruals, and for the quarter start date in a roll-forward.

Syntax and arguments

Example

A subscription company tracks deferred revenue on the first day of each quarter, for the quarterly roll-forward.

Deferred Revenue Start of Quarter =
CALCULATE(
    SUM('Deferred_Revenue'[Balance]),
    STARTOFQUARTER('Calendar'[Date])
)

In a Q4 2026 row, the filter is October 1, 2026. The measure returns the deferred revenue balance on that day.

Example: a second, different use

The quarter start date as a label for a quarterly table, so each row shows the date the quarter begins.

Quarter Start Date = CALCULATE(MIN('Calendar'[Date]), STARTOFQUARTER('Calendar'[Date]))

Things to watch

In business terms

STARTOFQUARTER supports the quarter-start balance for the roll-forward of deferred revenue, accruals and receivables. It is the tool used to show that a balance carried from the prior quarter's close.

Related functions

All DAX functions · View as Markdown · DAX fundamentals