Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 added a column not through the query editor:
B&R = IF(
COUNTROWS(
FILTER(Table2,
SEARCH(Table2[Project],
Prospects[PROJECT], 1, 0)
)
),
1,
0
)
I added a column not through the query editor:
B&R = IF(
COUNTROWS(
FILTER(Table2,
SEARCH(Table2[Project],
Prospects[PROJECT], 1, 0)
)
),
1,
0
)
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.