Please note that I have a report that include multiple columns I used to convert its output with PowerQuery, the problem is the "Dates" column not all its input is the same, and what I want is to be read as "dd-MM-yyyy" format, but PowerQuery return error for some dates while some others are read as date.
Any solution will be highly appreciated for the sample dates column in the attached file (1 sheet for the source data & 1 sheet for PowerQuery Output that converted errors to null)
If certain steps is required for the solutions will be highly appreciated if mentioned in details as I'm still new in PowerQuery
Thanks in advance.
Bookmarks