Forum Discussion

Anmolgan's avatar
Anmolgan
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

How to convert decimal date to Date type?

I want to convert all the dates that are in format of 01.10.2019 to 1/10/2019, like this I tried directly using the Date converter in the Power Query but it does not work and there are many date form...
Need Help
Show and Tell
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anmolgan ,

     

    If you want to convert "dd.mm.yyyy" as the date format, we can just add "de-AT"or some other culture code in the Table.TransformColumnType function like following:

     

     

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjDUMzTQMzIwtFTSUTJUitWJVgLyDWEiRkqxsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Date = _t, Value = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Value", Int64.Type}},"de-AT")
in
    #"Changed Type"


    Best regards,

     

Anmolgan's avatar
Anmolgan
Icon for Post Prodigy rankPost Prodigy
6 years ago

amitchandak  Do I need to create custom query for this?

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Create a new column