Forum Discussion
Cumulative Cash Flow By Week - Next Year
Hi sudhakar111
I modified my solution on the previous post to accomodate your request
Here the new solution
https://drive.google.com/drive/folders/1YNAFA2azeKaADsmyPNAbi-8mLoeC6uBg?hl=it
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Hi sudhakar111 ,
Thanks for reaching out to the Microsoft fabric community forum.
The issue appears to stem from using the YearWeekNr field for your cumulative calculation, as it resets each year. This causes the running balance to function within the current year but not carry forward into the next. To address this, I recommend adding a continuous week index to your Date table that does not reset annually.
By creating a Week Rank column using a dense rank over the Date field, you will have an uninterrupted sequence of weeks for your entire model. Your cumulative inflow and outflow measures can then reference this continuous rank, and your opening balance will only need to be retrieved once from your source table. With these adjustments, your cash balance measure will consistently carry forward across multiple years, eliminating the need for complex filtering logic and resolving the issue with the running balance.
Thank you,
Tejaswi.
Thank you