Forum Discussion

purnima13's avatar
purnima13
Icon for Helper I rankHelper I
8 years ago
Solved

Dax expression- if two columns between certain number

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 !

General Comment
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

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

2 Replies