Downloads
DAXTime intelligence: balancesIntermediate

OPENINGBALANCEQUARTER

Evaluates a balance at the start of the calendar quarter in the filter context.

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

Returns: A value (a scalar).

What it does

OPENINGBALANCEQUARTER returns a balance as it stood at the start of the quarter. The opening balance for Q2 is the closing balance at the end of Q1. Finance teams use it for quarterly roll-forwards of deferred revenue, receivables, accruals and inventory, and for the quarter-start check in a board pack.

Syntax and arguments

Example

A subscription business tracks deferred revenue, which is cash received for service not yet delivered. The controller wants the balance at the start of each quarter for the quarterly roll-forward.

Deferred Revenue Opening Q =
OPENINGBALANCEQUARTER(SUM('Deferred_Revenue'[Balance]), 'Calendar'[Date])

In a row for Q2 2027, the measure returns the deferred revenue balance on the first day of April 2027, which is the closing balance of the first quarter.

Example: a second, different use

The opening receivables balance for one business unit, filtered on the unit in the report.

AR Opening Q =
OPENINGBALANCEQUARTER(
    SUM('AR_Snapshot'[Balance]),
    'Calendar'[Date],
    'AR_Snapshot'[BusinessUnit] = "Services"
)

Things to watch

In business terms

OPENINGBALANCEQUARTER supports the quarterly roll-forward of deferred revenue, receivables and accruals, the start-of-quarter check in the close, and the audit trail that proves the balance carried forward from one quarter to the next.

Related functions

All DAX functions · View as Markdown · DAX fundamentals