Forum Discussion
Issues Closed each Month
Hello All,
I have a requirement where I have to show the Issues that were open for > 10 days. I have written the below measure to get this:
Days =
Var Inp = Calculate(MAX(Table[HISTORY_CREATED]), Table[HISTORY_STATUS] = "In Progress")
Var Acc = Calculate(MAX(Table[HISTORY_CREATED]), Table[HISTORY_STATUS] = "Accepted")
Return
CALCULATE(NETWORKDAYS(Inp,Acc,1))
Now when i filter this by month, I see duplicates of issues for some months. Suppose an issue was "in progresss" on 20th June and was "closed" on 2nd July, it would show on both June and July's data. Below is a sample data:
| Issues | status | Date |
| A | In Progress | 01-01-2023 |
| A | Closed | 02-02-2023 |
| B | In Progress | 03-03-2023 |
| B | Closed | 04-04-2023 |
| C | In Progress | 14-02-2023 |
| C | Closed | 16-02-2023 |
an someone please help me with the requirement
1 Reply
Kish1999 I'm not sure of the exact requirement here but this may help, 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
