I have a column with 'YES/NO' type data in table 1 correspond a NAME like below.
TABLE 1 :
NAME YES/NO
Peter NO
JOHN. YES
MARY NO
LILY YES
I would like to have a column (result list)in table 2 return all the NAME with NO value of table 1. How should I address this to the result list column? which formula should I use?
Solved! Go to Solution.
Something like SELECT(Table1[Name],[Yes/No]=FALSE). One side note.. please avoid using special characters like "/" with column names.
Something like SELECT(Table1[Name],[Yes/No]=FALSE). One side note.. please avoid using special characters like "/" with column names.
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |