Forum Discussion
Weekly opening balance
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?
lc_finance unfortunately i'm not able to share the complete .pbix .
The problem is that "Dimdate'[Week Nummer]<VALUES('Dimdate'[Week Nummer])" doesn't work for the first week every year.
It gives a blank on week 1 every year.
Hi Oomsen ,
I understand that you cannot share it for confidentiality reasons.
But maybe it's possible to share a sample of it? A sample of it with the problem
Seeing the file would make it easier to help you find the issue.
Regards
LC
lc_finance below my test file.
The "opening" measure isn't running if you ask me.
In my report i would like to see visuals between today and the next 6 months.
A relative date filter would be the best solution for this i guess?
lc_finance do you have any suggestion?