Format with dot as thousands separator and comma as decimal separator

[PieroPinzone95]

Hi guys, I would like to convert the format as shown above... i start with comma thousands separator and dot as decimal separator... i want the opposite

[Anonymous · Accepted solution]

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