cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gpraveenonline Frequent Visitor
Frequent Visitor

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

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
Inatech
2 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

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

Hi @gpraveenonline,

Thanks for your sharing.Smiley Happy

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tjd Established Member
Established Member

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

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.

2 REPLIES 2
Moderator v-yuezhe-msft
Moderator

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

Hi @gpraveenonline,

Thanks for your sharing.Smiley Happy

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tjd Established Member
Established Member

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

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.