unable to convert date column format from text to date

[Anonymous]

Hello ,
My date Column contains Date ,text(no yf) and N/a because of which i am unable to convert it to Date column , please help ....

[Anonymous · Accepted solution]

Hi  @Anonymous , 

Here are the steps you can follow： 

1. Power Query – Transform – Replace Valus .  

Value To find: No YF  

Replace With: No need to fill in, show blank 

2. In one operation:  

Value To find: #N/A  

Replace With: No need to fill in, show blank 

3. Select this column - right-click -Change Type – Data/Time 

Best Regards, 

Liu Yang 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly 

[Anonymous]

@Anonymous  thank you for your reply , dates are not filtering by month could you please help here

[vicky_]

You can only have date values in a date column. You can consider either removing error rows, or replacing them with a default value.