topic unable to convert date column format from text to date in DAX Commands and Tips

unable to convert date column format from text to date

Anonymous — Tue, 23 May 2023 05:29:06 GMT

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 ....

vicky_ — Tue, 23 May 2023 05:43:07 GMT

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

Anonymous — Thu, 25 May 2023 08:44:55 GMT

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 — Mon, 05 Jun 2023 12:42:41 GMT

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