Thousand and decimal separator in text measure

[Unknown]

Hello.

I have a measure calculating the sum of two columns.

The result I get is in the following format: 10.131,50

However, if I transform it into text by adding the currency, I get the result in this format: 10,131.50 EUR

Any idea of why the thousand and decimal separators change when the number changes to text?

Thanks

[v-chenwuz-msft]

Hi @Unknown ,

Please change the system data format and use FORMAT() to change it.

FORMAT(SUM('Table'[Column1]),"#,##0.00")

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

What is the locale setting on the PC where you do this?