Duration to seconds

[davidz106]

In my souce have duration given as mm:ss, for example: 02:15 as in 2 minutes and 15 sec.

Power BI understands this 02:15:00 as 02 hours 15 minutes and 00 seconds. Any idea how could I get it to understand it as min:sec. 

I can add "00:" infront of every value in my source but I would like to find a better way.

[Payeras_BI]

Hi @davidz106 ,

What about adding it in Power Query before loading to the model?

[Vijay_A_Verma · Accepted solution]

There is no better way other than pushing any transformation/conversion to source itself. If you do it at Power BI side, at the best, it will slightly underperform than source.

If you want to do it in Power BI, before Changed Type step, prefix "00:" in this column and then do Changed type. You can issue a Table.Replace command. Example below where Time is the column name

= Table.ReplaceValue(Source,each [Time],each "00:"&[Time],Replacer.ReplaceValue,{"Time"})

Default behavior of Power BI can't be changed.