Forum Discussion
Solved
Cumulative backlog to date
I am trying to create a line graph in Power BI to show the difference between a number of opened tickets vs resolved tickets on a daily basis. I then want to show a line graph of the cumulative data....
andrew_hardwick Couple small changes since there are blank dates... But you should be set now! Let me know.
I would like some help here as well please. I have followed the steps and managed to get the numbers working and used a line graph.
The issue I am facing is that the numbers tend to continue for the future weeks though there is (obviously) no data for those dates.
In the image, the Week24 is from 10/08/2020 till 16/08/2020. I don't have any data past those dates. But the backlogs for the NEXT week, Week25, shows as 12 (I've got no idea where that's coming from). And that same value goes on all the way till the end of the year, which is Week53.
Below are the relationships and measures that I have used:
Opened = COUNTA('Main'[Date (Ticket Created)])
Resolved = CALCULATE(COUNTA('Main'[Date (Ticket Solved)]), USERELATIONSHIP(Week[Dates], 'Main'[Date (Ticket Solved)]))
RT Balance = CALCULATE([Balance], FILTER(ALL(Week), Week[Dates] <= MAX('Main'[Date (Ticket Solved)])))
Backlog = CALCULATE('Main'[RT Balance], Week[Year]="2020-21")
Resolved = CALCULATE(COUNTA('Main'[Date (Ticket Solved)]), USERELATIONSHIP(Week[Dates], 'Main'[Date (Ticket Solved)]))
RT Balance = CALCULATE([Balance], FILTER(ALL(Week), Week[Dates] <= MAX('Main'[Date (Ticket Solved)])))
Backlog = CALCULATE('Main'[RT Balance], Week[Year]="2020-21")
Any help with this would be great. Thanks.