Cannot convert some cells to date format when they are clearly dates

[Anonymous]

I am having an issue converting a column from excel full of dates for a date format. For some reason it is able to convert some of the cells to dates (cells in italics), while others give an error when converting to a date (cells not in italics). This issue is happening to some cells which have the exact same value - see 24/05/2022 cells in the attached image.

Is there a reason why it cannot convert to a date when they are clearly dates? 

Thank you!

[amitchandak]

@ , if you system date format is US and you are using Uk format date it might give and issue

refer https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/...

You can create a new column too

date(( right(DD__MM__YY[date],4)), (mid(DD__MM__YY[date],4,2)) ,(left(DD__MM__YY[date],2)))