Downloads
DAXTime intelligence: balancesIntermediate

OPENINGBALANCEYEAR

Evaluates a balance at the start of the year in the filter context, with an optional fiscal year end.

Syntax
OPENINGBALANCEYEAR(<expression>, <dates> [, <filter>] [, <year_end_date>])

Returns: A value (a scalar).

What it does

OPENINGBALANCEYEAR returns a balance as it stood at the start of the year, which for a fiscal year means the start of the fiscal year. For a company with a June 30 year end, the opening balance for fiscal 2027 is the balance on June 30, 2026. Finance teams use it for the annual roll-forward of equity, cash, fixed assets and inventory, and for the opening balance in the audited financial statements.

Syntax and arguments

Example

A company with a calendar year end builds the annual roll-forward of its bank balance. The opening balance for each year comes from the daily balance table.

Cash Opening Year = OPENINGBALANCEYEAR(SUM('Bank_Balances'[Balance]), 'Calendar'[Date])

In a 2027 row, the measure returns the balance on the first day of 2027, which is the same as the closing balance of 2026. The annual roll-forward then shows the opening, the inflows, the outflows and the closing balance.

Example: a second, different use

For a June 30 fiscal year, the year end argument goes last, after the optional filter. The balance shown is the balance at the start of the fiscal year that contains the report date.

Equity Opening FY =
OPENINGBALANCEYEAR(
    SUM('Equity_Balances'[Amount]),
    'Calendar'[Date],
    ALL('Equity_Balances'[Entity]),
    "6/30"
)

Things to watch

In business terms

OPENINGBALANCEYEAR supports the annual roll-forward of cash, equity and fixed assets, the opening balance check for the year-end audit, and the fiscal year reporting that a board or lender expects. It ties the statements from one year to the next.

Related functions

All DAX functions · View as Markdown · DAX fundamentals