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.
Hi,
My goal is to find the average resolution time for the incidents. Below are the DAX queries. I am getting incorrect Average resolution time. The correct average resolution time is 31:57 (HH:MM). My result is 12:05 (HH:MM). Please let me know if I am missing anything here.
1. I converted Time coumn to round to the nearest minutes .
DATESINPERIOD is a time intelligence function that works only with standard date table that is marked as date table.
@tamerj1 Thank you for the response. What can I use instead of DATESINPERIOD for calculating average resolution time for the last 30 days (time is based on Resolved At date/Time field.)
you may try
'Source'[Resolved At] >= MAX(Source[Resolved At]) -30,
'Source'[Resolved At] <= MAX(Source[Resolved At]),
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 |
---|---|
47 | |
22 | |
20 | |
15 | |
13 |
User | Count |
---|---|
49 | |
41 | |
39 | |
19 | |
19 |