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

3 Replies

  • 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)

  • camargos88's avatar
    camargos88
    Community Champion
    6 years ago

    Hi Anonymous ,

     

    Have you tried to multiply the value by -1 ?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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