Comparing negative numbers in DAX?

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")

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

Hi,

use the following formula:

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

Regards FrankAT

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