1000 seperator comma

[bkoenen]

Hello,

I imported my data from an sql database into excel, from there to BI. SQL has no comma's so my values what where 65,61 become 6561 the problem is that bi sees this as a value of 6561,00I want it to be € 65,61 (check row3)

How do i this? 

Regards Björn

[v-chuncz-msft · Accepted solution]

@bkoenen,

You may check steps in The Advanced Editor.

[petrovnikitamai]

i'm not sure

try to Config of Region in you windows

like in this

https://community.powerbi.com/t5/Desktop/Can-t-input-calculated-column-formulas/m-p/552360/highlight...

[bkoenen]

Hi,

My regional settings are ok, check the printscreen.