Dax expression- if two columns between certain number

[purnima13]

Hi all,

What I basically want to do is clasify a row as valid or invalid if 

Column A is between values 5 and 6

Column B is between values -3 and -4 (beware of the negative numbers)

Row_Type = if(('04 GD'[Column A] >=5 ||  '04 GD'[Column A] <=6 )&&  ('04 GD'[Column B]<= -3 || '04 GD'[Column B]>= -4 ),"Valid","Invaid")

There is a logical mistake which I am not able to figure out.
Please help !

[Zubair_Muhammad · Accepted solution]

Hi @purnima13

Replace OR with AND

Row_Type=
IF (
    '04 GD'[Column A] >= 5
        && '04 GD'[Column A] <= 6
        && '04 GD'[Column B] <= -3
        && '04 GD'[Column B] >= -4,
    "Valid",
    "Invaid"
)

[purnima13]

@Zubair_Muhammad Thank you 🙂