Forum Discussion

Mederic's avatar
Mederic
Icon for Post Patron rankPost Patron
3 years ago
Solved

Message "DataFormatError"

Hello, I have a range named "Tab" with dates in columns, After some transformations, if I change the column "Attribute" to date type, I have a column with errors. How to correct the last step to t...
Need Help
  • AlienSx's avatar
    AlienSx
    3 years ago

    Hi, Mederic . Feed Power Query with correct date representation in "MMM-yy" format. As far as I know in "fr-FR" locale the date must be like "janv.-23", not "janv-23" and so on.

Mederic's avatar
Mederic
Icon for Post Patron rankPost Patron
3 years ago

Hello AlienSx ,

Thank you for your message and sorry for the late reply.
I hadn't thought about the regional settings, indeed the 2 steps below work and solve the problem
thanks again

Regards

#"Changed Type with Locale" = Table.TransformColumnTypes(#"Unpivoted Other Columns", {{"Attribute", type datetime}}, "fr-FR"),
    #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type with Locale",{{"Attribute", type date}})