Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
I think you're going to have to give some sort of details of what you're talking about. What date, where, how...?
Proud to be a Super User!
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?
Proud to be a Super User!
Thanks Horseman. It seems PowerBI is hardcoded to use American settings which doesnt seem right.
How would I go about using Date?
Proud to be a Super User!
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.
Proud to be a Super User!
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?
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |