Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
This date is in the format dd/mm/yyyy
How is it that it ends up with errrors when switching the data type from 'text' to 'date' ?
How to fix it?
thx for helping!
Solved! Go to Solution.
@adrien5555 Your Locale Setting must not be US - while your data source is set up to the US date format.
Look at the picture - I changed my default to UK and got the same error as you!
so you should probably split by delimiter and then re-assemble in the order DD/MM/YYYY
not sure the 2nd part of value considered as Month as i see any values has >12 error'd
can you try with parse tool under transform
@Anonymous : already tried the parse => same errors
@adrien5555 Your Locale Setting must not be US - while your data source is set up to the US date format.
Look at the picture - I changed my default to UK and got the same error as you!
so you should probably split by delimiter and then re-assemble in the order DD/MM/YYYY
Thanks. It worked for me fine, without doing additional Dax
Changing the local language option within PBI made it work.
I had to set it again from text to date, though.
Thanks!
Yes it does look like those are giving the errors!
I can't duplicate this tough... Added charachters, spaces before dates, formatted as Text still Query Editor recognizes immediately all dates as dates
It comes from a Google Spreadsheet.
there are no spaces before or after dates....
Thx for all your answers!!
I could be wrong, but that looks like you're translating from mm/dd/yyyy instead of dd/mm/yyyy to me.
@adrien5555 Are there additional spaces in the values that are throwing errors?..
Also what is your data source?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |