Format with dot as thousands separator and comma as decimal separator

Hi  PieroPinzone95 ,

Your regional settings determine what character is used as the thousands separator. 

You can consider using the Format() function to implement it, but it ends up in text formatting

FORMAT function (DAX) - DAX | Microsoft Learn

 

Here are the steps you can follow：

1. Create calculated column.

Flag =
var _thousand=ROUNDDOWN('Table'[Column1]/1000,0)
var _hundreds=ROUNDDOWN(MOD('Table'[Column1],1000),0)
var _decimal=ROUND(MOD('Table'[Column1],1),1) * 10
return
_thousand &"."&_hundreds&","&_decimal

2. Result:

 

Best Regards,

Liu Yang

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