Concert duration to format DD HH MM SS

Hi. Have you tried in the edit queries to change data type to "Time"?

You can read more about it here:

https://docs.microsoft.com/en-us/power-bi/desktop-data-types#determine-and-specify-a-columns-data-type

 

Regards,

Hi Anonymous , 

You could try below M code to see whether it work or not(because there is no time format like  DD hh:mm:ss ,this will convert it to text instead of time)

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwMtA31DdUMDSyMjKwMjRVitWBihrrmyoYGloZGAARQtRSH6gkFgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [date = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"date", type datetime}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each DateTime.ToText([date], "dd HH:mm:ss"))
in
    #"Added Custom"

 

 

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.