Forum Discussion
Counting Open Cases and Closed Case per Month
Hello,
I'm new to Power BI and I'm trying to create a report with the total open cases for the month and total closed cases. Can someone help with me figure out how I can accomplish this?
| ID | Created Date | Closed Date | Status |
| 1 | 10/1/2022 | 11/2/2022 | Closed |
| 2 | 10/5/2022 | 10/25/2022 | Closed |
| 3 | 10/20/2022 | 10/25/2022 | Closed |
| 4 | 10/31/2022 | Open | |
| 5 | 11/1/2022 | 11/30/2022 | Closed |
| 6 | 11/15/2022 | 11/26/2022 | Closed |
| 7 | 11/28/2022 | Opem | |
| 8 | 12/2/2022 | 12/10/2022 | Closed |
| 9 | 12/9/2022 | Open | |
| 10 | 12/20/2022 | 12/28/2022 | Closed |
Expected Result:
| Month | Open Count | Closed Count |
| Oct-22 | 4 | 2 |
| Nov-22 | 3 | 3 |
| Dec-22 | 3 | 2 |
1 Reply
- Greg_Deckler
Community Champion
Phoenix12
Take a look at these two Quick Measures as I think you want something like them.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
