Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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?

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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")

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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")