powerbidaxpowerquerypowerbi-desktop

DataFormat.Error: We couldn't parse the input provided as a Date value

I have a column called date that is currently as data type text.

I try to change it to date and this is what happens:

enter image description here

The error says:

DataFormat.Error: We couldn't parse the input provided as a Date value.
Details:
    1/23/2022

I don't understand why.

I've been changing the data type of this column previously in other reports without problem.

Solution

  • Posting an alternative solution for awareness where one can select the Locale of the Data Transformation...

    1. Click on the ABC in the column header and then select Using Locale...
      Setep 1

    2. Then select Data Type Date and Locale English (United States)
      Step 2

    In Power Query, you can specify the Locale as the third parameter (eg "en-US"):

    Table.TransformColumnTypes(PreviousStep, {{"date", type date}}, "en-US")