Forum Discussion
Average Talk Time Issue
Hi I'm trying to calculate average talk time, and am having issues where the call goes into a new day: My measure is: Duration Average = VAR total_second = AVERAGEX( Cal...
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.