Convert negative revenue in a column to positive

[PowerNewbie98]

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 paid	10
Pens	-20
Staples	-5
Refunded items	50
paper	-10

[mlsx4]

Hi @PowerNewbie98 

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

[Idrissshatila · Accepted solution]

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

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

Follow me on Linkedin
Vote For my Idea💡

[PowerNewbie98]

Thank you!