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
PowerNewbie98
New Member

Convert negative revenue in a column to positive

Hi all 🙂 New user to Power BI so trying to get my head around it. 

 

My aim is to get power bi to look up look through the data I have in column 2 - and replace all negative figures with positive. Any advice would be greatly appreicated!

 

My data looks something like this:

 

Acct Type$
Fees paid10
Pens-20
Staples -5
Refunded items50
paper-10
1 ACCEPTED SOLUTION
Idrissshatila
Super User
Super User

Hello @PowerNewbie98 ,

 

you go into Power query and click on the column you need to fix the signs and then under transform => scientific = > Absolute value

 

Idrissshatila_0-1693378996809.png

 

Idrissshatila_1-1693379012905.png

 

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

3 REPLIES 3
mlsx4
Super User
Super User

Hi @PowerNewbie98 

 

In DAX you can use the formula ABS (https://learn.microsoft.com/en-us/dax/abs-function-dax)

Idrissshatila
Super User
Super User

Hello @PowerNewbie98 ,

 

you go into Power query and click on the column you need to fix the signs and then under transform => scientific = > Absolute value

 

Idrissshatila_0-1693378996809.png

 

Idrissshatila_1-1693379012905.png

 

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Thank you!

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.