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" )
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
User | Count |
---|---|
348 | |
99 | |
62 | |
49 | |
49 |
User | Count |
---|---|
325 | |
119 | |
79 | |
68 | |
63 |