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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
GordyM1
Regular Visitor

Negative Totals

I have a simple table imported from Excel which gives me a negative as a total. The sales come through as a negative number hence the negative total. What I want to end up with is the Totals as below but not being a negative. I'm new to PowerBI so not sure how to do that?

 

Account NameAprilMay
Purhases343670198604
Sales-474912-273557
Total-131242-74953
1 ACCEPTED SOLUTION
jennratten
Super User
Super User

Hello - if you are just trying to reverse the signs, you can multiply by -1.  If you are wanting something different please provide an example of the expected result.

jennratten_0-1654055412777.png

 

= Table.TransformColumns(#"Changed Type", {{"April", each _ * -1, type number},{"May", each _ * -1, type number} })

View solution in original post

2 REPLIES 2
jennratten
Super User
Super User

Hello - if you are just trying to reverse the signs, you can multiply by -1.  If you are wanting something different please provide an example of the expected result.

jennratten_0-1654055412777.png

 

= Table.TransformColumns(#"Changed Type", {{"April", each _ * -1, type number},{"May", each _ * -1, type number} })

Hi, thanks works brillianty.

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors