Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
97 | |
87 | |
76 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |