Forum Discussion
How to show current month created request, completed request and carry forwarded requests ?
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!
Community Championojhassonu 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!
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
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!
