Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

reverse a value

Is it possible to reverse the value eg -$12,000 to become $12,000 and visa a versa $11,500 becomes -$11,500
  • camargos88's avatar
    camargos88
    6 years ago

    Hi Anonymous ,

     

    Have you tried to multiply the value by -1 ?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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)