Different Date formats in Same Column

When you get data with multiple date formats in same column, it may result errors while transforming the Data.

I have noticed that many business data users are clearing those errors manually, which may cause delay in final report creation / inaccurate results !

In this video I have explained how to transform such columns where multiple date formats are placed and resulting errors while transforming the data!

#powerquery #powerbi