How to set my closing balance for the previous month as the opening balance for the next month

[kristenk14]

Good Day,

I have created the following measure to calculate the closing balance for each month, since the closing balance isn't necessarily on the last day of the month,

closing_balance (EoM) = CALCULATE([flow_value], LASTNONBLANK(PARALLELPERIOD(investor_flows[date], 0, MONTH), [flow_value] ), investor_flows[flow_type] = "Balance")

It works perfectly, how can I then use this as the opening balance for next month?

Thank you

[kristenk14]

Will the formula work if the closing balance of the previous month is not the very end of the month, but just the last day for which there is a balnce calculated?

[kristenk14]

Hi, @amitchandak 

I tried it,

opening_balance = OPENINGBALANCEMONTH([flow_value], investor_flows[date], investor_flows[flow_type] ="Balance")

and it is not working. Am I doing something wrong with the formula?

[amitchandak]

@kristenk14 , use openingbalancemonth month

refer openingbalancemonth,openingbalancequarter, openingbalanceyear : https://youtu.be/6lzYOXI5wfo