How to convert mm:ss to seconds (duration)

[diskovered]

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

[mwegener · Accepted solution]

Hi @diskovered

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

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

[Anonymous]

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?

[mwegener]

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".

[diskovered]

Thanks. 

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