Power BI supports three types of Opening Balance and three types of Closing Balance DAX functions.
These functions only work with import mode and do not support the direct query mode.
1 . CLOSINGBALANCEMONTH: Evaluates the expression at the last date of the month in the current context.
Syntax: CLOSINGBALANCEMONTH(<expression>,<dates>,<filter>)
2. CLOSINGBALANCEQUARTER: Evaluates the expression at the last date of the quarter in the current context.
Syntax: CLOSINGBALANCEQUARTER(<expression>,<dates>,<filter>)
3. CLOSINGBALANCEYEAR: Evaluates the expression at the last date of the year in the current context.
Syntax: CLOSINGBALANCEYEAR(<expression>,<dates>,<filter>)
4. OPENINGBALANCEMONTH: Evaluates the expression at the first date of the month in the current context.
Syntax: OPENINGBALANCEMONTH(<expression>,<dates>,<filter>)
5. OPENINGBALANCEQUARTER: Evaluates the expression at the first date of the quarter, in the current context.
Syntax: OPENINGBALANCEQUARTER(<expression>,<dates>,<filter>)
6. OPENINGBALANCEYEAR: Evaluates the expression at the first date of the year in the current context.
Syntax: OPENINGBALANCEYEAR(<expression>,<dates>,<filter>)
Watch Practical video
All six types of OPENING BALANCE & CLOSING BALANCE DAX Functions explained step by step.
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.