Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
we have a system with error tickets whose processing time we monitor. The tickets have a start date and an end date. We need to calculate on a rolling basis for the last thirteen months how many tickets have met the runtime target (<=45 days), how many have met the maximum runtime (>45, >=180 days) and how many have exceeded the maximum runtime (>180 days).
I tried a few things in Power BI, but couldn't get it to work.
I have implemented this in Excel for illustration purposes and deposited it at the link below.
https://drive.google.com/drive/folders/1UyDjtjScJxHRZLh_8eevhxrycSXqtBZA?usp=sharing
@hmo , You have create a measure like this with a independent date table
Meausre =
var _max = if( isblank(max(Table[closed_on])) || max(Table[closed_on]) >Max(Date[Date]) , Max(Date[Date]), max(Table[closed_on]))
var _min = if( min(Table[date_of_creation]) <Min(Date[Date]) , Min(Date[Date]), max(Table[date_of_creation]))
return
datediff(_min,_max, days)
Very similar to this but do not join - https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
The next step is to create an independent range table and using group by ticket_number, create a new measure to use this new table. Refer to this video - https://youtu.be/CuczXPj0N-k
I'm sorry, I don't understand. I'm not good enough at Power BI.
I do not understand what the above Measure brings for a result and what I should do with it.
Can anyone else help here?
Thanks in advance!
Thanks for reply, I'll check tomorrow.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |