Forum Discussion
Cumulative backlog to date
andrew_hardwick Couple small changes since there are blank dates... But you should be set now! Let me know.
Hi medwards807
OK I have opened and resolved, which are both measures.
Then I have two calculations. The first is a measure called balance.
Balance = [Opened]-[Resolved]
I then use another measure called RT Balance (Running Total). This is the one that I use on my graph.
RT Balance = CALCULATE([Balance],FILTER(ALL('Date'),'Date'[Date]<=max('Date'[Date])&&NOT(ISBLANK('Date'[Date]))))
This looks like this-
Hope that helps?
Hi andrew_hardwick,
I was reading through this post and tried oud your solution without success.
I think my situation might be slightly different and hoped you could help on this one to :
I prepared a simplified version of my raw data (here below)
So basically, i have a ticket on each line.
Each ticket has a opened date, a target for resolution and an actual resolution date
At a given date (today in below example) a ticket is either resolved, late (backlog) or opened and still within time window allowed for resolution.
A ticket may have been late (backlog) at a certain time
What i'm trying to achieve:
I would like to set up a cumulative backlog that will show overtime the cumulated backlog and be able to split the line between site A and site B
Thanks for your help and your time !
| Source | ticket ID | Date opened | Target closure date | closed date | is backlog | is or has been backlog |
| Site A | 1 | 01/01/2016 | 16/01/2017 | 15/01/2017 | ||
| Site B | 2 | 01/01/2016 | 16/01/2017 | 18/02/2017 | yes | yes |
| Site B | 3 | 01/01/2017 | 16/01/2017 | 18/01/2017 | yes | |
| Site A | 4 | 01/02/2017 | 16/02/2017 | 15/02/2017 | ||
| Site A | 5 | 01/02/2017 | 16/02/2017 | 17/02/2017 | yes | |
| Site B | 6 | 01/05/2017 | 16/05/2017 | 16/06/2017 | yes | yes |
| Site B | 7 | 01/05/2017 | 16/05/2017 | 15/05/2017 | ||
| Site A | 8 | 01/07/2017 | 16/07/2017 | yes | yes | |
| Site A | 9 | 01/07/2017 | 16/07/2017 | yes | yes | |
| Site B | 10 | 01/07/2017 | 16/07/2017 | yes | yes | |
| Site A | 9 | 15/07/2017 | 30/07/2017 | |||
| Site B | 10 | 15/07/2017 | 30/07/2017 |