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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hey,

is the value in the datasource -76% (and thus being a string)
or is it -0.76 and did you use the modeling function in Power BI to make it a percentage?

If the first, you should, and need to model it like -0.76 and use the modeling function to make it a percentage.

If the last, you can create a dax formula looking something like this:

COLUMN = IF(Columnwith-76% > -1 && < -0,49;"yes";"no")