Problems calculating the average number of ATH calls

[Syndicate_Admin]

Good morning, I press my name is pablo and I am from Argentina and I have a problem to get the average talk time of a telephone exchange, AHT calls, if I on the excel calculate with the average function that value gives me correctly but on power bi I do not find the turn, what I do is calculate the total time of conversation but I do not find the way to get that average, I attach a capture of what I have and if anyone can help me thank you very much.-

Best regards;

Pablo

[amitchandak]

@Syndicate_Admin , If this in time format you have first convert and take avg

new measure =

var _avg = averageX(Table, hour([Talk Time])*3600 + Minute([Talk Time])*60 + Second([Talk Time]))
return
Time(0,0,_avg)

or

new measure =

var _avg = averageX(Table, hour([Talk Time])*3600 + Minute([Talk Time])*60 + Second([Talk Time]))
return
format(Time(0,0,_avg), "hh:mi:ss" )

[Syndicate_Admin]

Hello, use your solution but I am doing something wrong so it does not work for me, I tell you how to arm it

var_avg = averageX(Sheet1, hour([suma AHT])*3600 + Minute([suma AHT])*60 + Second([suma AHT]))

return

time (0,0, var_avg)

I pass the capture, you could tell me where I am wrong

Sdos.

Pablo

[Syndicate_Admin · Accepted solution]

Thanks There I found the mistake I had, you are a genius or genius!