Duration in Power Bi

Question

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 date/time format, something like 12/31/1899 HH:MM: SS.

How do I get my data in the HH:MM:SS format in Power Bi? I need to calculate the average of that column.

Please help.

Note: I've tried changing the column in excel to General format and then changing the format to duration in Power BI, that gives me the format as DD:HH:MM:SS.

Greg_Deckler can you please help me?

abbasg · Answer

Shivrajvk&nbsp;please share some sample data (after removing all the sensitive information), with desired out come.

shivrajvk · Answer

Hi AbbasG&nbsp;, I have the data as below in in Excel,&nbsp;&nbsp;And what I have in Power Bi is like&nbsp;&nbsp;I want the data in the format HH:MM:SS.&nbsp;&nbsp;

abbasg · Answer

Shivrajvk&nbsp;I think you can use the FORMAT function here.Additionally, you can also refer the following solution -&nbsp;https://community.powerbi.com/t5/Desktop/Extracting-only-minutes-and-seconds-from-a-date/m-p/2201488#M805419Hope it helps!

shivrajvk · Answer

AbbasG&nbsp;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?&nbsp;

Forum Discussion

Duration in Power Bi

4 Replies

Related content

how to add duration using power query

notebook duration time issue

duration format

Reset Performance analyzer- For consistent duration

Duration format