Concert duration to format DD HH MM SS

[Anonymous]

Hello I'm new to Power BI and I would like to know if there is a way to convert in the Power Query editor the time format DD/MM/YYYY HH:MM:SS to a more readable format like DD HH:MM:SS?  
Thank you in advance

[ibarrau · Accepted solution]

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

Regards,

[dax · Accepted solution]

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.

[ibarrau · Accepted solution]

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

Regards,