Compare greater than 0 but less than 2 in dax using IF statement

[Dee]

Hi all,

I would love to do a comparison that checks if the value in a column is greater than 0 but less than 2,

eg

IF( A[BBB]>0 AND <= 2, "RRR", " NNN), "000)

Any idea how I can tweak that for it not to throw an error.

[Gordonlilj · Accepted solution]

Hi,

Something like this should work:

IF( Table[column] > 0 && Table[column] <=2,"ResultTrue","ResultFalse")

or if you want to use switch:

SWITCH(TRUE(),Table[column] > 0 && Table[column] <=2,"ResultTrue","ResultFalse") 

[Dee]

Thank you!!