Convert text to dates in a column with mixed date types

Is this what you try to achieve? You can use the custom column option and create the rules needed to do the transformation displayed in the tables. Hope this helps. 

Hi Anonymous ,

Do you have another column identify the date column type? For example the date 2/1, If can be first day of february or the second day of january if you do not have any other column can identify the format.

If you do have one, we can create a custom column depends on it easily in Power Query Editor.

if [Type] = "MMDD" then Date.FromText([Date]) else Date.FromText([Date],"fr-SN")

BTW, pbix as attached.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.