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.
Hi Sean
No, I do not have a Calendar Table, so I suspect this is where I am going wrong. Do you know where I find one, or how to create one?
PS, I really am new to this :-)
Thanks,
Andy
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.