topic Re: Converting positive values to negative values in DAX Commands and Tips

Converting positive values to negative values

Austin360 — Thu, 24 Mar 2022 07:07:00 GMT

Please I need help on how to convert positive values within a column to negative values.

tamerj1 — Thu, 24 Mar 2022 07:22:51 GMT

New Column =
IF ( Table[Column]<0, Table[Column], -Table[Column])

Austin360 — Thu, 24 Mar 2022 07:24:54 GMT

Thanks for the quick response

tamerj1 — Thu, 24 Mar 2022 07:30:29 GMT

You can also use

New Column =
- ABS ( Table[Column] )

Austin360 — Thu, 24 Mar 2022 08:38:47 GMT

Thanks alot.

I was hoping to use an else statement alongside your statement above to change the all negative to positive.

Like all positive to negative and negative to positive.

Austin360 — Thu, 24 Mar 2022 08:50:53 GMT

Column = if(GL_ENTRY_[amount] < 0, GL_ENTRY_[Amount] *-1,-GL_ENTRY_[Amount] *1)

was hoping this would do the trick.

But its not , Kindly help

tamerj1 — Thu, 24 Mar 2022 09:07:06 GMT

Austin360
If you want convert all positive to negative and all negative to positive
Column = - GL_ENTRY_[amount]

Austin360 — Thu, 24 Mar 2022 09:10:17 GMT

Thanks a million