Forum Discussion
Date Column type Conversion
Hi,
I would like to convert date column in US date format.
I have DD/MM/YYYY
I want to convert into MM/DD/YYYY.
Thanks
After converting the type, manually add the area code that supports DD/MM/YYYY.
If you want the results to be displayed as MM/DD/YYYY, you should set the display format in the PowerBI or Excel interface.
Hi damit230183,
Thank you for using Microsoft Community Forum.
To convert the date from DD/MM/YYYY to MM/DD/YYYY format in Power BI, you need to open Power Query, rightclick on the date column, choose Change Type by Using Locale, select Date as the data type, and set the Locale to English (United Kingdom).
After applying these changes and closing Power Query, the dates will display correctly in the mm/dd/yyyy format, depending on your system's regional settings.
If further formatting is needed, you can adjust it under the Modeling tab using a custom format like mm/dd/yyyy .
If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!
Thank you.
7 Replies
Hi,
My apologies for late response as I was out of office for 10 days.
I have not tried yet any of solution as just saw it today. I will try this week then update the status.
Thanks
Hi damit230183 ,
Thank you for your update.
Just checking in -- have you had a chance to review and try the provided solution? Kindly share the status whenever you get a chance.
Looking forward to your response.
Best regards,
Sahasra.
After converting the type, manually add the area code that supports DD/MM/YYYY.
If you want the results to be displayed as MM/DD/YYYY, you should set the display format in the PowerBI or Excel interface.
Hi damit230183,
Thank you for using Microsoft Community Forum.
To convert the date from DD/MM/YYYY to MM/DD/YYYY format in Power BI, you need to open Power Query, rightclick on the date column, choose Change Type by Using Locale, select Date as the data type, and set the Locale to English (United Kingdom).
After applying these changes and closing Power Query, the dates will display correctly in the mm/dd/yyyy format, depending on your system's regional settings.
If further formatting is needed, you can adjust it under the Modeling tab using a custom format like mm/dd/yyyy .
If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!
Thank you.
Hi damit230183,
I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.
If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.
Hi damit230183
We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If my answer resolved your query, please mark it as "Accept Answer" and give Kudos if it was helpful.
If you need any further assistance, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!
