cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
prathameshsable
Helper I
Helper I

Need to calculate average of time column

Hi Team,

 

I have a column with time format. I am trying to calculate the average waiting time (AWT) which is the average of all the rows in the column.

 

AWT
00:00:51
00:02:54
00:00:20
00:03:21
00:00:08
00:00:13
00:00:05
00:00:43

 

Average of the time is

00:01:04

 

However, I am not able to directly aggregate the column in KPI as Select the AWT field. It just gives me the Latest Time or  Earliest time or Count in the Fields

 

Can anyone help here. I need to then calculate the AHT as well. Its very important for my call centre calculations KPIs

 

Regards,

Prathamesh Sable

1 ACCEPTED SOLUTION
v-qiuyu-msft
Community Support
Community Support

Hi @prathameshsable,

 

You can create a measure below:

 

Measure = FORMAT(AVERAGE(Table1[AWT]),"HH:MM: SS")

 

q2.PNG

 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-qiuyu-msft
Community Support
Community Support

Hi @prathameshsable,

 

You can create a measure below:

 

Measure = FORMAT(AVERAGE(Table1[AWT]),"HH:MM: SS")

 

q2.PNG

 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Thank you.. This really helped me to fix instead of converting the time to seconds & then calculating it & then re-converting it back. This is good. Thank you very much

hey man, how did you calculate the average handling time (kindly provide the dax formula)?

It's good, but it's text and I can't change it to type Date Time, to put the average in a graph

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!