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.
Here's a link on how to create a Calendar table
http://www.powerpivotpro.com/2015/02/create-a-custom-calendar-in-power-query/
Then just set up the relationships and create the measures as in my picture above.
Hope this helps. Let me know if you have any other questions.
Thats great. thanks for that, I now have a Calendar. I have built my report using the measures you stated and the Calendar and it is now almost there, I have the balance and RT Balance showing. The ony remaining issue I see is that some of the lines do not yet have a resolved date, they are still being worked on. This therefore gives me a negative RT Balance at the start as their is no date assigned. Instead I would like this open entries to appear on the latest RT Balance day, i.e. today.
Any idea how I could achieve this?
andrew_hardwick Couple small changes since there are blank dates... But you should be set now! Let me know.
Thats great Sean, thanks for your help :-)
Hi guys, using the opened date from the tickets table everything looks awesome, but using the dates from the date table I got this behavior about to get the negative values at the beginning of the table. Any suggestion?
diegoadum I'm not entirely sure what your issue is, can you elaborate and I will see if I can help?
Hello all,
The calculation for the backlog worked perfectly. However, I would like to display the sum of "points" assigned to each ticket instead of the count of the opened tickets, closed tickets, and RT balance.
Ticket Number Opened Date Closed Date Points
1234 01-01-2019 02-01-2019 7
1254 01-02-2019 01-09-2019 3
5432 01-31-2019 02-01-2019 1
1456 01-22-2019 02-08-2019 4
So I would like to display the sum of points for the opened, sum of points for the closed, and sum of points for the backlog.
Thank you in advance!
