How to show current month created request, completed request and carry forwarded requests ?

[ojhassonu]

Hi Guys,

I have a requirement to show

I have data related to helpdesk requests, and user wanted to know how many requests created and completed in the month.

The main clash is here some requests which are created in a month and completed in another month or year. 

For example:

in January 2021, 

Total Requests created: 100

Total Requests Completed: 80

So the remaining 20 requests to carry forward to next months so in Feb 2021, 

Total Requests created=130

Total Requests completed=141

here out of 141 requests, 15 requests ( January)+126(Feb) and another 5(Jan)+4(Feb) =9 requests are moved to next month, untill requests completed.

We have two date fields in table, Created Date and Completed Date.

If user selected Year = 2021 and Month=Jan

Then data should be shown as below

If user selected Month=Feb, then it should show data as below

any lead would be really appreciated. 

Attached pbi sample file

https://drive.google.com/file/d/1j-Zl-exvwT3o4loPB7mmlaYT0yepdpoz/view?usp=sharing

Regards,

Sonu

[ojhassonu]

@littlemojopuppy Thank you for your time and help. I really appreciate it. 🙂

[littlemojopuppy]

@ojhassonu what you want to do is calculate the total number of requests created since the beginning of time and then subtract the total number of requests completed.  All the measures are in the attached pbix.  Hope this helps!

[ojhassonu]

@littlemojopuppy 
Thanks for the reply, my requirement is monthwise created requests and completed.  There are few requests which created in a month and completed in another month/ year. 

So I would like to show data in the given format as above screenshot attached in the question.

Regards,

Sonu

[littlemojopuppy · Accepted solution]

@ojhassonu apologies for leaving out the counts of carried forward and completed the following month.  Wasn't quite obvious in your initial request.  Check the updated pbix.

About "show data in the given format as above screenshot attached in the question"...I trust that you're fully capable of taking the measures I've written and arranging them how you need them.  I'm giving the courtesy of including the matrix to demonstrate that the math works.  Myself and others are happy to assist you with the help you need, but we are not here to do your work for you.

Hope this helps!