Forum Discussion
Date Format Issues
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?
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")
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")