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.
Solved! Go to Solution.
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.