Forum Discussion

Regular Visitor

3 years ago

Duration in Power Bi

I have a column named duration in which data is in the format hh:mm: ss The data is displayed correctly in Excel but when I import the excel file in Power Bi, the format of the column changes to a ...

Memorable Member

3 years ago

Shivrajvk I think you can use the FORMAT function here.

Additionally, you can also refer the following solution - https://community.powerbi.com/t5/Desktop/Extracting-only-minutes-and-seconds-from-a-date/m-p/2201488#M805419

Hope it helps!

Shivrajvk

Regular Visitor

3 years ago

AbbasG The Format function works by the output is in a text format. I want to calculate the average of the entire duration column. Is there any way to do that?

Forum Discussion

Duration in Power Bi

Related content

how to add duration using power query

notebook duration time issue

duration format

Reset Performance analyzer- For consistent duration

#Duration function