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
I'm trying to calculate average talk time, and am having issues where the call goes into a new day:
My measure is:
Can anybody see what is wrong with my formula?
Thanks!
Try RETURN DAXDay&":"&TIME(DAXHours, DAXMin, DAXSecond)
--Nate
Unfortunately, that still returns strange results:
I can see the second part of the calculation has worked correctly. The top call is indeed 17 minutes long, but the first half of the calculation is still adding almost a month to the call time...
As you can see from the next result down on my screenshot, all my other calls are accurate. It's just when the date changes mid-call it can't work it out.
Hello @M_B_
Have you tried to substract call end time with call start time and represent the value as seconds?
Hi @StenbergAleksi
I thought that was essentially what my DATEDIFF was doing within this sum?
What formula would I need for a straight subtraction End Time-Accepted Time which would return a value in seconds?
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 |
---|---|
39 | |
19 | |
17 | |
16 | |
15 |
User | Count |
---|---|
50 | |
24 | |
21 | |
17 | |
16 |