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

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:

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?

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors