Forum Discussion

Frequent Visitor

1 year ago

Solved

Convert positive values to negative

Hi, I have a column with both positive and negative values. I want Power BI to show all the valus as negative. How do I do that?

Super User

1 year ago

you can use PowerQuery to create a custom column like so:

the formula:

Number.Abs([Value]) * -1

The table will look like this

Hopefully, this provides what you are looking for.

Regards,

Tom

TomMartens
Super User
1 year ago
Hey trndlnd ,

then create a DAX measure like so:

All negative (ms) = SUMX( 'All Negative' , ABS( 'All Negative'[Value] ) * -1 )

Regards,

Tom
- trndlnd
  Frequent Visitor
  1 year ago
  This helped me out!
  Thank you TomMartens !
trndlnd
Frequent Visitor
1 year ago
Sounds like this would solve my problem, but I am in DirectQuery mode, so PBI won't let me create a custom column like this.