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

[gpraveenonline]

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.

[v-yuezhe-msft · Accepted solution]

Hi @gpraveenonline,

Thanks for your sharing.

Thanks,
Lydia Zhang

[Crunchy]

I had a similar situation where the data was in the "dd.mm.yyyy" format so Power Query could not covert it into a date format. I created a custom column:

[tjd · Accepted solution]

If you're dealing with some clients that use mm/dd/yy and others that use dd/mm/yy, I would suggest that you just use the format: "17-Mar-16" instead of either dd/mm or mm/dd to avoid confusion among your clients.  It is an available date format in PowerBI.

[v-yuezhe-msft · Accepted solution]

Hi @gpraveenonline,

Thanks for your sharing.

Thanks,
Lydia Zhang