Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PK_W_T
Regular Visitor

Filtering a Query Based on a Related Table

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.

1 ACCEPTED SOLUTION
PK_W_T
Regular Visitor

I added a column not through the query editor:

 

B&R = IF(

COUNTROWS(

FILTER(Table2,

SEARCH(Table2[Project],

Prospects[PROJECT], 1, 0)

)

),

1,

0

)

View solution in original post

2 REPLIES 2
PK_W_T
Regular Visitor

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
Regular Visitor

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.