Downloads
DAXTime intelligence: balancesIntermediate

CLOSINGBALANCEQUARTER

Evaluates a balance on the last date of the calendar quarter in the filter context.

Syntax
CLOSINGBALANCEQUARTER(<expression>, <dates> [, <filter>])

Returns: A value (a scalar).

What it does

CLOSINGBALANCEQUARTER returns the balance at the end of the quarter. Like the month version, it is the right tool for balances such as receivables, inventory, deferred revenue and accruals, which must not be added across time. Finance teams use it for the quarter-end balance sheet, the quarter-end aging of receivables and the quarterly reconciliation.

Syntax and arguments

Example

A controller prepares the quarter-end aging of receivables. The AR snapshot has the open balance for each customer on each day, so the quarter-end balance is the balance on the last day of the quarter.

Closing AR Q = CLOSINGBALANCEQUARTER(SUM('AR_Snapshot'[Balance]), 'Calendar'[Date])

In a Q3 2026 row, the measure returns the receivables on September 30, 2026. Summing the three months' balances would give a figure that means nothing.

Example: a second, different use

Quarter-end inventory value for one warehouse, with the filter placed inside the function.

Inventory Value Closing Q =
CLOSINGBALANCEQUARTER(
    SUM('Inventory'[Value]),
    'Calendar'[Date],
    'Inventory'[Warehouse] = "Dallas"
)

Things to watch

In business terms

CLOSINGBALANCEQUARTER supports the quarter-end balance sheet, the aging of receivables at each quarter end, quarter-end inventory counts, and the balances used in covenant and borrowing base reports. Lenders often ask for quarter-end figures, so the measure must match the closing trial balance.

Related functions

All DAX functions · View as Markdown · DAX fundamentals