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

VasTg's avatar
VasTg
Memorable Member
6 years ago

Anonymous 

 

Add a custom column as below

 

=if [Column1] <= -0.49 and [Column1] >= -1 then "Yes" else "No"

 

Replace Column1 with your actual column name

 

If this helps, mark it as a solution

Kudos are nice too