SOLVED

Power Query - Multiply column by negative 1

Steel Contributor

Hello,

 

How could I multiply a column by negative 1 if the value is a negative?  Meaning that the I would be converting anything negative to a positive for that column.  I would rather not add a column. 

 

thank you. 

3 Replies
best response confirmed by Tony2021 (Steel Contributor)
Solution

@Tony2021 

You may apply ABS from here

image.png

wow. I didnt think it could be so easy. Thank you!

@Tony2021 , you are welcome

1 best response

Accepted Solutions
best response confirmed by Tony2021 (Steel Contributor)
Solution

@Tony2021 

You may apply ABS from here

image.png

View solution in original post