Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 !
Solved! Go to 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" )
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" )
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |