Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Image from Error
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-...
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |