How can i solve this date error as i am getting text in the Date column

[Hemant_rangdal]

when i try to convert text format to date, it shows Error. how can i solved it ?

[WanderingBI]

Maybe one thing to add:

When you click on the "abc" symbol and change it to date Power Query will transform all the values in your column to dates. If you have a value like "a" then this evaluation will fail because Power Query has no way to find a date that would fit the description. So the Error value is created correctly.

[dk_dk]

Hi @Hemant_rangdal 

How do you want to treat cases when the date is missing? This is up to you to decide.

Do you want those rows removed from the dataset? filter the blank* rows

Do you want a default date value to be used in such case? replace the blank values with the default date

One way or another, you would need to make sure your text column only contains date values, before you try to change the data type to Date.

Hope this helps!

*EDIT: I didn't see the first time around in the screenshot that the cell is not blank, but there is an integer number in it. The question still stands: how do you want those rows to behave in your data?