Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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

‎06-16-2020 06:49 PM

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

Message 1 of 4
3,412 Views
0
1 ACCEPTED SOLUTION
camargos88
Community Champion
Community Champion

‎06-17-2020 08:14 AM

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

Message 3 of 4
3,357 Views
3 REPLIES 3
camargos88
Community Champion
Community Champion

‎06-17-2020 08:14 AM

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!



Message 3 of 4
3,358 Views
Anonymous
Not applicable
In response to camargos88

‎06-22-2020 04:15 AM

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

Message 4 of 4
3,339 Views
0
harshnathani
Community Champion
Community Champion

‎06-16-2020 09:47 PM

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)

Message 2 of 4
3,381 Views

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.

View All