Closing balance one month to opening balance the next month

[Anonymous]

Hello again! 

I have a new question for you which I hope you can help me with. 

The table looks like this: 

Utgående Balans = closing balance ( Which is summarizing the variables down below)
The other variables is salaries, taxes, invoices, accounts receivable, cash on the bank

The thing I want to do is that the closing balance shall be added to the next month. So for example in june: Closing balance is 14 011 984. I want to create a new variable which shows opening balance for each month. And the opening balance for july is the closing balance for june. 

How can I do this? 

Best regards! 

[Anonymous]

Thanks for your answer!

I tried to do it the way you showed. But as I understand it doesnt work if you have measures as I have. In this table all columns are measures.  The table that shows " utgående balans" is a measure which is the sum of adding all the other columns/measures together. The measure looks like this: 

Utgående balans = [Lönekostnad ex. soc]+[Skatt och sociala]+[Leverantörsreskontra]+[Kundreskontra]+[Bankkonto]

Is there another solution or am I doing it the wrong way?

[amitchandak]

@Anonymous , for that you have build like inventory cumulative

example

Inventory / OnHand
CALCULATE(firstnonblankvalue('Date'[Month]),sum(Table[Intial Inventory]),all('Date')) + CALCULATE(SUM(Table[Ordered]),filter(date,date[date] <=maxx(date,date[date]))) - CALCULATE(SUM(Table[Sold]),filter(date,date[date] <=maxx(date,date[date])))

Power BI Inventory On Hand: https://youtu.be/nKbJ9Cpb-Aw