Forum Discussion

trndlnd's avatar
trndlnd
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?    
Need Help
Tips and Tricks
  • TomMartens's avatar
    TomMartens
    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

TomMartens's avatar
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's avatar
trndlnd
Frequent Visitor
1 year ago

This helped me out!

Thank you TomMartens !