Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.