Calculating a measure for Averaging duration in the format of ss:mm:hh

[Awollet33]

Hi all,

I want to get an average duration while leaving it in the format ss:mm:hh

Is this possible in PowerBI?

Thanks,

Adam

[v-yangliu-msft · Accepted solution]

Hi  @Awollet33  ,

Created some data:

Here are the steps you can follow：

1. Create measure.

Measure = FORMAT(AVERAGE('Table'[date]),"ss：mm：hh")

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[daxer-almighty]

@Awollet33 

I don't know what this format ss:mm:hh is but yes, you can. First, convert everything into any common unit of time - for instance, hours or minutes or seconds or even nano-seconds if you feel brave enough 🙂 - and then calculate the average of the figures, lastly convert the result back to the weird format of yours.