Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
diskovered
Helper III
Helper III

How to convert mm:ss to seconds (duration)

How do I convert this to seconds either via measure or m. Help is much appreciated. Thanks

 

convert.PNG

1 ACCEPTED SOLUTION

Hi @diskovered

 

format the column with Power Query (M) as duration.

With Duration.TotalSeconds([Column]), you get the seconds.

 

Duration.png

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


View solution in original post

5 REPLIES 5
Ramaka_bnd
Regular Visitor

Split the column into two columns. One for minutes and one for seconds with the type number.

Then add a new column with like this
AddColNewSpeaktime = Table.AddColumn(ChangeColType, "Ø Sprechzeit", each #duration(0,0,[Ø Sprechzeit.1],[Ø Sprechzeit.2])),
AddcolNewWaittime = Table.AddColumn(AddColNewSpeaktime, "Ø Wartezeit", each #duration(0,0,[Ø Wartezeit.1],[Ø Wartezeit.2])),
#duration(0,0,0,0) need the type number

Hi @diskovered

 

format the column with Power Query (M) as duration.

With Duration.TotalSeconds([Column]), you get the seconds.

 

Duration.png

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


Anonymous
Not applicable

Could you please explain this in more detail?

 

I have durations in my data set that are, for example, 7 minutes 17 seconds, but powerBI auto formats the duration to be 7 hours 17 minutes 0 seconds. How can I change this?

 

What is your source?

Is there a "Changed Type" step?

Maybe you could insert a "Add Prefix" step before the "Changed Type" step and change the value to this format "00:07:17".

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


Thanks. 

 

Got mine to work = Table.TransformColumns(#"Changed Type",{{"Value - Copy", Duration.TotalSeconds, type number}})

Helpful resources

Announcements
PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors