text to date

[Anonymous]

Hello.
I am new to power BI and maybe this is an easy question, however, here it is:

I have a text column, storing dates in the form 27.03.2021 and when I try to convert it to date type I receive error for some rows and for some other it works.
Is there any other way to do this type of conversion?
Thank you

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

What date format do you use?  mm/dd or dd/mm?

The error might be because your locale (format) doesn't match the  date format.

Try right clicking on the column header then Change Type -> Using Locale.

Select the Date Type : Date.

You then need to choose the locale of the origin of the data.  So as the dates I'm converting are in USA (mm/dd) format, I choose English (United States) as the Locale.

Regards

Phil