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 !
Go to Solution.
Replace OR with AND
'04 GD'[Column A] >= 5
&& '04 GD'[Column A] <= 6
&& '04 GD'[Column B] <= -3
&& '04 GD'[Column B] >= -4,
View solution in original post
@Zubair_Muhammad Thank you 🙂
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!