DateFormat.Error: we couldn't convert to number

[RWR]

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

[v-diye-msft]

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.

[pranit828]

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.

[amitchandak]

@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-...