We may face the following situation when importing data to Power BI:
From the data source, the whole column is in the right date format. Once being imported into Power BI, the column will have dates in two formats as below:
Mon 16/11/20 throws an error.
3/15/2021 indicates the correct format.
Through this blog, I will show you how to use Power Query and DAX to convert different date types into unified format.
Read more...
Convert to date type in different formats in the Date column (2).pbix