Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi. Have you tried in the edit queries to change data type to "Time"?
You can read more about it here:
Regards,
Happy to help!
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.
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.
Hi. Have you tried in the edit queries to change data type to "Time"?
You can read more about it here:
Regards,
Happy to help!