Forum Discussion
Format Hour time
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.
Anonymous,
You may split it into 3 columns by colon, then use #duration function to add a custom column.
1 Reply
Anonymous,
You may split it into 3 columns by colon, then use #duration function to add a custom column.