return the value of yes/no type column

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 Solved
0 1 107
1 ACCEPTED SOLUTION

Something like SELECT(Table1[Name],[Yes/No]=FALSE). One side note.. please avoid using special characters like "/" with column names.

View solution in original post

1 REPLY 1

Something like SELECT(Table1[Name],[Yes/No]=FALSE). One side note.. please avoid using special characters like "/" with column names.

Top Labels in this Space