Question

In Power Query, you import a CSV where a column named OrderDate contains values like '13/07/2024' (day/month/year). After loading, Power BI shows several errors in this column and some dates appear swapped. You need to convert the text to proper date values without generating errors caused by the report's regional settings. What should you do?

Accepted Answer

Use 'Change Type With Locale' and specify English (United Kingdom) as the locale when converting the column to Date

Answer

Change the column type to Date using the standard 'Change Type' command and accept the default locale

Answer

Replace all errors with null values, then change the column type to Date

Answer

Split the column by the '/' delimiter and set each resulting column to Whole Number