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

FrankAT's avatar
FrankAT
Community Champion
6 years ago

Hi,

use the following formula:

If ( Table[% Decrease] >= -1 && Table[% Decrease]  <= -0.49 ; "Yes" ; "No")

 

Regards FrankAT