Forum Discussion
Weekly opening balance
For my cash forecast i would like to create weekly overview (see attached).
Week 44 is working correct, but after that i would like to see that the closing balance of week 44 is de opening balance in week 45, etc.
I'm currently facing circularity.
Hi Oomsen ,
you are right. There was one part of the calculation that I had not fixed.
You can download the new version from here.
I rechecked calculations manually, now all seem to be good.
Let me know if it also works for you!
LC
Interested in Power BI and DAX templates? Check out my blog at www.finance-bi.com
lc_finance do you have any suggestion?
17 Replies
Hi Oomsen ,
I do not see the file you attached.
Can you include your Power BI sample again? (for example, uploading it to OneDrive and the including a link to it)
That will help in better understanding your current formulas
Regards
LC
Interested in Power BI and DAX templates? Check out my blog at www.finance-bi.com
lc_finance this is the first time i share via OneDrive, i hope it will work.
Hi Oomsen ,
I looked at your file and you can find my proposed solution attached.
I created a new measure for opening that does exactly what you mentioned: take the closing for the prior week.
Here is the DAX code for it:
opening new = CALCULATE([closing],'Dimdate'[Weeknummer]=VALUES('Dimdate'[Weeknummer])-1)And here is a screenshot:
Is this what you are looking for?
Let me know if you need more help
LC
Interested in Power BI and DAX templates? Check out my blog at www.finance-bi.com