topic reverse a value in DAX Commands and Tips

reverse a value

Anonymous — Wed, 17 Jun 2020 01:52:03 GMT

Is it possible to reverse the value eg -$12,000 to become $12,000 and visa a versa $11,500 becomes -$11,500

Anonymous — Wed, 17 Jun 2020 04:47:12 GMT

HI Anonymous ,

You can create a column.

COLUMN1 =

SWITCH(

True(),

'Table'[Actual] > 0 , - 'Table'[Actual],

ABS('Table'[Actual])

)

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

camargos88 — Wed, 17 Jun 2020 15:14:56 GMT

Hi Anonymous ,

Have you tried to multiply the value by -1 ?

Anonymous — Mon, 22 Jun 2020 11:15:45 GMT

yes, I eventially also came to this conculsion; thank you for helping on this one.