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.
I got 3 whole number columns which I am mergin to create data column. But I am getting this wierd error. It cant covert some values to date type format. For example, 12 3 2019 was successfully converted to 03/12/2019 but 13 3 2019 gave parsing error.
I appreciate any troubleshooting inputs.
Solved! Go to Solution.
You are importing dates which are in a different format than your local settings e.g 13/4 or 4/13
Delete the step in Applied Steps.
Right click the column
Change Type -> Using Locale
...and pick the format of the country the dates come from
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsIt looks like Power Query is using mm/dd/yyyy to convert the dates. So it is treating 12/3 as Dec 3, not Mar 12. Therefore you get this error as there is no 13th month.
How are you merging these together are you trying to build a string, then convert it to date?
If you want to use a string it's usually best to use the yyyy-mm-dd format as it is unambiguous or you could pass a specific culture parameter to Date.FromText to specify how the date format should be interpreted.
Or you could use the #date function which you can call using #date( <yyyy>, <m> ,<d>) , so in your case you could just pass in your 3 numeric columns directly
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsYou are importing dates which are in a different format than your local settings e.g 13/4 or 4/13
Delete the step in Applied Steps.
Right click the column
Change Type -> Using Locale
...and pick the format of the country the dates come from
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |