fix date mixed format us and uk in same column

[Anonymous]

I have Data From Excel has two date format US & UK in same column, I tried to use ( Using Local ) it doesn’t help because same dates hard to figure like 09/08/2023 but actually this table only for Sep i would like a soulation will help me also when i will add other months 
Example of my table below by the wat Column {My Note} not belong to the table i just did it manual for explain

[Ashish_Mathur · Accepted solution]

Hi,

My opinion would be to resolve this issue in MS Excel itself.  f you are amenable to my approach, then share the download link of the Excel file and i will share the process of correction.

[Anonymous]

Thanks for your kindly support

I can’t upload because of restricted internet security firewall in my org so I will screen shoot of excel templet.

[v-rongtiep-msft]

Hi @Anonymous ,

You can change the type of the column using locale and set it to UK format. To do this, right click on the column name, select Change Type, then Using Locale, then pick Date and en-GB.
You can check the regional settings of your system and make sure it is set to UK. Then restart the Power BI desktop and refresh the query editor.
You can check the region of the SharePoint library if you are using one as a source. It often defaults to US. You can change it in the site settings.

Powerquery - Editor is forcing US Date format including for parameters when source data is in UK Date format - Stack Overflow

Solved: US date and UK date format - Microsoft Fabric Community

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

A grateful of your support and helping me, I tried Using Locale solution but it doesn’t work in days from 1 to 12 because it is so hard to know it is a month or a day.

This data came from attending system and I reported to the IT company so tell they fix it am searching for other solution.

I can’t upload and data because it is restricted from firewall in my Organization but I post a screen shoot of the excel templet Replying to Mr.Ashish