UK Date not Showing Correctly

[Anonymous]

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

[KHorseman]

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

[Anonymous]

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

[KHorseman]

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?

[Anonymous]

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

How would I go about using Date?

[KHorseman]

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

[Anonymous]

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

So that doesnt seem to be the issue.

[KHorseman]

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.

[Anonymous]

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?