Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Comparing negative numbers in DAX?

Hi, this might be a silly question but I can't figure out how to achieve it.   I have a financial table that has a column called "% Decrease" which shows the % decrease of payments. An example valu...
Need Help
Show and Tell
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ,

     

    Go to "Data view">"Modeling">"New Column",then add a dax expression as below:

     

    Column = IF('Table'[% Decrease]>-1 &&'Table'[% Decrease]<-0.49,"Yes","No")

     

     

    Then you will see:

     

     

    Best Regards,
    Kelly

amitchandak's avatar
amitchandak
Super User
6 years ago

If the column is already in table then create a column. 

 

new column = if(table[% Decrease]>=-100  && table[% Decrease]<=-49,"Yes","No")

 

If the % decrease is a measure create a measure

measure = if([% Decrease]>=-100  && [% Decrease]<=-49,"Yes","No")

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin