cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Varan_15
Helper II
Helper II

Date format issue

Hi All,

facing date format issue like one file (MM/DD/YY) another one file contains (DD/MM/YY) how to change as a same format in powerbi.

examble :

Capture.PNG

2 REPLIES 2
HotChilli
Super User
Super User

In Power Query, right-click the column and 'Change Type' ->using Locale, and you pick the date format you want to transfer from (for example, UK or US).

From the picture I think you have appended the 2 files and the column is text so you need to do this before appending the 2 files.

PhilipTreacy
Super User
Super User

Hi @Varan_15 

 

Do you know which files contain dates in which format?  If you don't then this will be hard/impossible as is.  Ideally you should be getting the dates in the same format.  Failing that you need to deal with them separately, e.g. US format dates converted separately to UK dates.

 

Even if you tried something like

 

try Date.From([Dates] , "en-UK") otherwise Date.From([Dates] , "en-US")

 

 

it's not perfect because it can't tell if 07/04/2022 is April 7th or July 4th.

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors