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.

AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
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.