topic Re: Currency format for negative numbers in Tabular cube in DAX Commands and Tips

Currency format for negative numbers in Tabular cube

Natalet — Wed, 07 Jul 2021 10:37:04 GMT

Hi, All!

I want to format numbers as a currency (always with $ at the beginning). I tryied to use standard format for currency for my calculated measure, because I always use it and it works fine for Revenue measure, i.e. in Excel it shows $213 for value 213. But the problem in my case is that I have a measure "Profit" and it could be negative and I don't want to format negative currency value in brackets (as it format default in tabular cube for currency format), i.e. $-213 it shows in Excel as $(213).

I tried to use custom format: $##,###.##;$-##,###.## instead, but in Excel it shows rubbles (Russian currency). I don't need rubbles, I want dollars! How can I fix it?

Here is an example how it shows my custom format in Excel:

Re: Currency format for negative numbers in Tabular cube

Fowmy — Wed, 07 Jul 2021 10:54:59 GMT

Natalet

Under Modeling Tab choose Custom Format and apply the below format

$#0.00;$-#0.00;$#0.00

Re: Currency format for negative numbers in Tabular cube

Natalet — Wed, 07 Jul 2021 11:00:30 GMT

Thanks for advise! But again I received in Excel rubbles (it's because of loacle I guess and I need dollars)

Here is a screen what I get when use currency English format in cube (first column) and when I use your format string (second column)

Re: Currency format for negative numbers in Tabular cube

Fowmy — Wed, 07 Jul 2021 11:13:02 GMT

Natalet

It works for me, both in Excel and Power BI, my currency setting is below. Please change and check if it's differs.

Re: Currency format for negative numbers in Tabular cube

Anonymous — Wed, 07 Jul 2021 11:15:03 GMT

Natalet that solution should work, kindly try again.

Re: Currency format for negative numbers in Tabular cube

Natalet — Wed, 07 Jul 2021 11:15:30 GMT

Thanks!

Re: Currency format for negative numbers in Tabular cube

Natalet — Wed, 07 Jul 2021 11:19:21 GMT

Thanks! Defenetly it's because of locale( some o our users would have to switch locale, I didn't find another decision through DAX

Re: Currency format for negative numbers in Tabular cube

Prashanth1664v — Thu, 22 Dec 2022 05:15:58 GMT

Great...!, Thanks, It's working for me.
I want to know the logic behind this code $#0.00;$-#0.00;$#0.00
Positive;Negative;?