reverse a value

[Anonymous]

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

[camargos88 · Accepted solution]

Hi @Anonymous ,

Have you tried to multiply the value by -1 ?

[Anonymous]

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

[harshnathani]

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)