Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello Everyone,
I need some help with the following error "DateFormat.Error: we couldn't convert to number"
There is in the number two caracter, "." and "," and I am quit sure that it is the error.
I tried to convert the number by location (United States and Brazil), to around the number, to convert to text and I didn't have success.
My source is a text file imported from SAP.
Hi @RWR
If the above posts help, please kindly mark it as a answer to help others find it more quickly. thanks!
If not, please kindly elaborate more.
Hi @RWR
Not very clear as you have two country's format.
Can you please provide more info input and expected output in table format.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
@RWR , regional setting try the country with dot as thousand separator
Regional settings
https://docs.microsoft.com/en-us/power-bi/fundamentals/supported-languages-countries-regions
https://superuser.com/questions/1419853/power-bi-desktop-number-format-shows-american-format-in-visu...
https://blog.crossjoin.co.uk/2015/05/25/working-with-international-date-and-number-formats-in-power-...
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |