Forum Discussion

o59393's avatar
o59393
Post Prodigy
6 years ago
Solved

Date format change

Hi all   How can I convert a Jan 07 2020 to 01/07/2020 with power query?   I attach PBIX   https://1drv.ms/u/s!ApgeWwGTKtFdhjOrLr9_z4xQWZca?e=KpC6mb    Thanks.  
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Mine does it automagically if I just right-click on the column and switch to Date

    dejar
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8krMUzAwVzAyMDJQitWJVnIsKFIwNEXwfRMrFQxNEHz/5BIFA0MoPxYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Date = _t]),
    #"Tipo cambiado" = Table.TransformColumnTypes(Source,{{"Date", escriba date}})
    en
    #"Tipo cambiado"

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Mine does it automagically if I just right-click on the column and switch to Date

dejar
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8krMUzAwVzAyMDJQitWJVnIsKFIwNEXwfRMrFQxNEHz/5BIFA0MoPxYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Date = _t]),
#"Tipo cambiado" = Table.TransformColumnTypes(Source,{{"Date", escriba date}})
en
#"Tipo cambiado"