topic Re: Create a chart inferring historical data from start and end dates in DAX Commands and Tips

Create a chart inferring historical data from start and end dates

neilcotton — Thu, 20 Jun 2024 12:48:05 GMT

Good day, all.

I'm looking for some guidance on how we can create a chart that shows cummulative, historic data based on the start and end dates.

For example.

Imagine a helpdesk system that has the date a ticket was created and the date it was closed. I would like to be able to show a month based chart that shows how many tickets were open at the end of the month. To show the delta of working through a back log.

i.e

Jan 2024 | 10 tickets were created, and 6 were closed THEREFORE Jan 2024 = 4

Feb 2024 | 20 more were created, and 8 were closed THEREFORE Feb 2024 = 16 (4 + 20 - 😎

Mar 2024 | 15 more were created, and 20 were closed THEREFORE Mar 2024 = 11 (16 + 15 - 20)

Apr 2024 | 10 more were created, and 15 were closed THEREFORE Apr 2024 = 6 (11 +10 -15)

It doesn't matter if the tickets closed were from the month they were created, or from the backlog from previous months.

Any pointers would be appricated.

Re: Create a chart inferring historical data from start and end dates

lbendlin — Fri, 21 Jun 2024 18:36:39 GMT

Sounds like a straightforward scenario. What have you tried and where are you stuck?

Re: Create a chart inferring historical data from start and end dates

neilcotton — Tue, 25 Jun 2024 17:04:08 GMT

Hi lbendlin,

Thanks for the response. I'm not sure where to start, without creating manual calculations for each month.

Re: Create a chart inferring historical data from start and end dates

lbendlin — Tue, 25 Jun 2024 17:31:59 GMT

Something like this?