topic Re: Formatting with no decimal in DAX Commands and Tips

Formatting with no decimal

Anonymous — Tue, 30 Mar 2021 13:38:25 GMT

Hi guys I am using the format function to get rid of the decimals and use a comma to " thousands". I need to use format funcion since I am building a hybrid matrix.

I tried out

FORMAT([Ventas Netas],"#,##0") and FORMAT([Ventas Netas],"#,##") and none of them worked out

The values I would expect are

12,006

14,806

So I am getting a dot instead of a comma. Idk where my mistake is.

Re: Formatting with no decimal

amitchandak — Tue, 30 Mar 2021 14:28:31 GMT

Anonymous , Seem like you have a regional setting for a European country. Once you do that that setting will follow

, will taken as .

I think this can be changed by changing the regional setting.

Re: Formatting with no decimal

Anonymous — Tue, 30 Mar 2021 15:42:03 GMT

amitchandak

My regional setting is set to Peru.