Forum Discussion

davidz106's avatar
davidz106
Helper III
4 years ago
Solved

Duration to seconds

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 u...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    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. 

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

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.