I'm sure this must be straightforward but I cannot get my head around it.
I have a lengthy Power Query that includes a column that includes both dates and text. I need the column to be formatted explicitly as a date column (so that the output table can be selected using drop down month/year filters) but while still returning the text fields as they originally appear instead of errors/blanks.
The text fields vary so they needs to be based on the original content. I've tried to work out how to do it using a 'try' statement but I'm not having any luck.
Is anyone able to point me in the right direction please?
Bookmarks