Downloads
DAXTime intelligence: first and lastIntermediate

ENDOFQUARTER

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

Syntax
ENDOFQUARTER(<dates>)

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

What it does

ENDOFQUARTER returns the last day of the quarter in context. Inside CALCULATE it limits the measure to that day, which gives the balance at the close of the quarter. Finance teams use it for quarter-end receivables, deferred revenue, inventory and accruals, and for the quarter-end figures that go to a lender or a board.

Syntax and arguments

Example

The controller prepares the quarter-end aging. The receivables balance on the last day of each quarter is read from the AR snapshot.

AR Balance Quarter End =
CALCULATE(
    SUM('AR_Snapshot'[Balance]),
    ENDOFQUARTER('Calendar'[Date])
)

In a Q3 2026 row, the measure reads the balance on September 30, 2026. The result must match the receivables control account at that date.

Example: a second, different use

Quarter-end deferred revenue for a subscription business, with a filter on the product line.

Deferred Revenue Quarter End =
CALCULATE(
    SUM('Deferred_Revenue'[Balance]),
    ENDOFQUARTER('Calendar'[Date]),
    'Deferred_Revenue'[ProductLine] = "Annual Plans"
)

Things to watch

In business terms

ENDOFQUARTER supports the quarter-end balance sheet, the aging of receivables at quarter end, deferred revenue reconciliations and the quarter-end figures in lender covenant reports. The numbers should always tie to the closing trial balance.

Related functions

All DAX functions · View as Markdown · DAX fundamentals