Date Column type Conversion

Hi damit230183 , this should work:
= Text.From([DateColumn]),"en-US)

Reference below, 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.