Filtering a Query Based on a Related Table

[PK_W_T]

I have imported a table into PowerBI as a query.  I have a distinct table with a list of projects.  If the project name is listed within this table, I would like to have that line removed from the query.  I have the table and query linked by the project column.

[PK_W_T · Accepted solution]

I added a column not through the query editor:

B&R = IF(

COUNTROWS(

FILTER(Table2,

SEARCH(Table2[Project],

Prospects[PROJECT], 1, 0)

)

),

1,

0

)

[PK_W_T]

I am trying to at least add a custom column within the Prospects table that will tell me if the project is contained in the Prospects query and table2.

CONTAINS(Table2, Table2[Project], Prospects[Project]))

It says expression.error. The name Contains is not recognized.