Forum Discussion
Balances
Hi All, I am trying to create a formula for opening and closing balances in PowerBI. I am calculating the opening balance for the quarter (lets say Q4 2021 - which would be 1st Oct 2021 to 31...
Hi pxs2021
DAX includes functions for OPENINGBALANCEMONTH, OPENINGBALANCEQUARTER and OPENINGBALANCEYEAR (as well as closing balance). They might be helpful.