Date Format Issues

[Anonymous]

I've discovered my dataset has a date column made up of both UK and US date formats (both DD/MM/YYYY and M/DD/YYYY).

What is the best way to standardise this using Power BI?

[Anonymous · Accepted solution]

You can use DAX Format() function to get result

DD_MM_YY = FORMAT(Table[Date],"DD/MM/YYYY")

MM_DD_YY = FORMAT(Table[Date],"MM/DD/YYYY")