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"

1 Reply

  • 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"