Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Formatting date with inconsistent input data in same column

Hi all,   I'm having trouble formatting a column of date data which has two date formats from the raw data.   The input data has a mixture of d/m/yyyy and dd/mm/yyyy For example there is 2/8/2...
Need Help
mussaenda's avatar
mussaenda
Community Champion
6 years ago

Hi Anonymous ,

 

I cannot replicate your issue.

i tried these two dates and they can be formatted in power query. check this:

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