Forum Discussion

andrew_hardwick's avatar
andrew_hardwick
Helper III
10 years ago
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....
Need Help
  • Sean's avatar
    Sean
    10 years ago

    andrew_hardwick Couple small changes since there are blank dates...  But you should be set now! Let me know.

     

Sean's avatar
Sean
Community Champion
10 years ago

andrew_hardwick Couple small changes since there are blank dates...  But you should be set now! Let me know.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hey Sean , thanks a lot! I found this very helpful. I know the post is kind of old, but it's gold.

 

And I also have a question, I needed the RT Balance, and I also need to find the closed balance from previous periods. For example, this month I resolved three tickets that where created on previous months, I need to show that in the chart along the RT Balance, how would I write a measure for that? I have tried several things, but nothing seems to be working.

 

Any advice or guidance in the right direction would be appreciated. Thanks a lot!