Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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!
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:
@CApowerbi , 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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.