Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.