Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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]),