How to convert dd/mm/yyyy to mm/dd/yyy or any date format in Power BI? RRS feed

  • General discussion

  • For example : if you have a date dd/MM/yyyy. follow the steps


    1. Edit the table 

    2. Split the column with '/' custom delimiter

    3. Re-arrange the columns to see the month in first and date column to next and year to the last.

    4. Select all the three columns.

    5. Right click-> Merge columns with a custom delimiter '/'.

    6. Transform the column to change the data type to 'Date'



    Finally you see the column transformed. Its easy. Try it by yourself.

    Praveen Kumar G
    Thursday, July 28, 2016 11:03 AM

All replies

  • this doesnt work in 2016 coz after you have merged all 3 tables - the data type is text and when you change the type back to date it reverts to exactly how  it was before you starting splitting and merging
    Saturday, May 6, 2017 10:45 AM
  • The intended way to convert textual dates to dates in Power Query is to use function Date.FromText and supply the correct culture code as the 2nd parameter.
    Saturday, May 6, 2017 11:11 AM