Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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" )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |