Format with dot as thousands separator and comma as decimal separator

PieroPinzone95 — Wed, 26 Apr 2023 09:05:53 GMT

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

Re: Format with dot as thousands separator and comma as decimal separator

Anonymous — Fri, 28 Apr 2023 07:16:41 GMT

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

topic Re: Format with dot as thousands separator and comma as decimal separator in DAX Commands and Tips

Format with dot as thousands separator and comma as decimal separator

Re: Format with dot as thousands separator and comma as decimal separator