Format Hour time

[Anonymous]

Hi I´m new on Power BI and i need help please.

I´ve a column with format hh:mm:ss (duration upper than 24 hours). I typed the format hour and i´m getting the error attatchment.

How can i change the type format to [h]:mm:ss. I want average that column.

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may split it into 3 columns by colon, then use #duration function to add a custom column.