Skip to main content
Microsoft Idea

Power BI

Needs Votes

Calculate average time in hours/minutes/seconds

Vote (48) Share
Sykonba's profile image

Sykonba on 13 Jul 2015 18:07:56

It would be very useful to add the capability of calculating the average time in hours or minutes or even seconds. Currently, the average value returns a decimal format value, which is insignificant

Comments (5)
Sykonba's profile image Profile Picture

BI SBS on 05 Jul 2020 23:23:52

RE: Calculate average time in hours/minutes/seconds

I always used this in Excel. It was a surprise not find it in Power BI.

Sykonba's profile image Profile Picture

Vivekanand Kini on 05 Jul 2020 23:11:09

RE: Calculate average time in hours/minutes/seconds

This is a must have. For time based analysis the aggregation in decimals doesnt make sense.

Sykonba's profile image Profile Picture

Gabriel Grünberg on 05 Jul 2020 22:51:20

RE: Calculate average time in hours/minutes/seconds

This is a complete showstopper right now.

Sykonba's profile image Profile Picture

Thomas on 05 Jul 2020 22:07:37

RE: Calculate average time in hours/minutes/seconds

In complement, is there any way to convert a duration expressed in second to days/hours/minutes ?

Sykonba's profile image Profile Picture

Mark on 05 Jul 2020 22:05:32

RE: Calculate average time in hours/minutes/seconds

This is a big issue for me also, specially with the Google Analytics connector - do MS people monitor or comment on this?