Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION
camargos88
Community Champion
Community Champion

Hi @Anonymous ,

 

Have you tried to multiply the value by -1 ?



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

3 REPLIES 3
camargos88
Community Champion
Community Champion

Hi @Anonymous ,

 

Have you tried to multiply the value by -1 ?



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Anonymous
Not applicable

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

harshnathani
Community Champion
Community Champion

HI @Anonymous ,

 

 

You can create a column.

 

COLUMN1 =
SWITCH(
True(),
'Table'[Actual] > 0 , - 'Table'[Actual],
ABS('Table'[Actual])
)
 
1.jpg
 
 

Regards,
Harsh Nathani

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.