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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

UK Date not Showing Correctly

 

date issue.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

For some reason it is putting the day in as the month.  How would i get it to go the otherway round?

 

Locale Settings are UK

8 REPLIES 8
KHorseman
Community Champion
Community Champion

I think you're going to have to give some sort of details of what you're talking about. What date, where, how...?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

I up;loaded a pic but for some reason its not showing.  will try again

DATEVALUE takes your computer's locale settings for date order. Are you sure your locale settings are day/month/year and not month/day/year?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

Thanks Horseman. It seems PowerBI is hardcoded to use American settings which doesnt seem right.

 

How would I go about using Date?

DATE([year], [month], [day])





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

Checked the locale and it is showing dd/mm/yyyy.

 

So that doesnt seem to be the issue.

How about the Regional Settings in Power BI Options?

 

Anyway why not use DATE instead of DATEVALUE? It has an explicit argument order and it's tidier to code since you don't have to concatenate a string.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

In the calcodes column i have the code

 

calcodes = DATEVALUE("01"&"/"&[Month of the year]&"/"&[Year])

For some reason it is putting the month of the year as the day.... any idea?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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