Downloads
DAXTime intelligence: balancesIntermediate

OPENINGBALANCEMONTH

Evaluates a balance at the start of the month in the filter context.

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

Returns: A value (a scalar).

What it does

OPENINGBALANCEMONTH returns a balance as it stood at the start of the month. For a balance such as stock or cash, the opening balance of March is the same as the closing balance of February. Finance teams use it for the inventory roll-forward (opening, purchases, sales, closing), the cash roll-forward and the start-of-period check in a close review.

Syntax and arguments

Example

A warehouse manager reviews the inventory roll-forward for each month. The opening units are the stock on hand at the start of the month, from the daily snapshot table.

Opening Units = OPENINGBALANCEMONTH(SUM('Inventory'[Units]), 'Calendar'[Date])

In the March 2027 row, the measure returns the stock at the start of March. The roll-forward then reads opening units, plus receipts, minus issues, equals closing units.

Example: a second, different use

The opening cash balance for a bank account for each month, to start the month's cash report.

Opening Cash =
OPENINGBALANCEMONTH(
    SUM('Bank_Balances'[Balance]),
    'Calendar'[Date],
    'Bank_Balances'[Account] = "Operating"
)

Things to watch

In business terms

OPENINGBALANCEMONTH supports the inventory and cash roll-forwards in the month-end close, the opening balance check in a reconciliation, and the flow analysis that explains why a balance moved. Auditors ask for the roll-forward, so the opening figure needs to tie to the prior close.

Related functions

All DAX functions · View as Markdown · DAX fundamentals