Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Closing balance one month to opening balance the next month

Hello again! 

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

The table looks like this: 

 

CApowerbi_0-1686124519442.png

 

 

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! 

2 REPLIES 2
Anonymous
Not applicable

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?
 
 
 
 

CApowerbi_1-1686209766459.png

 

 

amitchandak
Super User
Super User

@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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.