I need to have the backlog model I build not resetting the cumulative balance (Open Tickets - Resolved Tickets) when the users selected a period.
In the mockup, if I selected a period Running Balance calculation resets, while I need it to consider the Running Balance of the last day before the period selected.
E.g.: In Week 1 the Running Balance is 129, in Week 2 it’s 338, but if I selected just Week 2 I lose Week 1 and Running Balance starts from 209, while it should be 338 (129+209).
I’ve seen many patterns like this resolved in the forum, but I was not able to apply to this.
Thanks for help
Less important, but need to know why I get a blank value is a slicer I made from the calendar?
Backlog.pbix (72.7 KB)