Average Minutes in hh:mm:ss format

[Anonymous]

Hi,

I am trying to show the average of filtered values in hh:mm:ss of entries in minutes as whole numbers in a Table.

I'm trying to replicate the following commands from Excel;

average values

divide by 1440

change the format to a Custom hh:mm:ss.

Thanks in advance.

[Pragati11 · Accepted solution]

Hi @Anonymous ,

There are similar threads for this issue on the forum:

https://community.powerbi.com/t5/Desktop/Average-Talktime-in-HH-MM-SS-format/m-p/1265351

[amitchandak]

@Anonymous , refer, if these can help

https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax