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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Ronniemaccagee
Frequent Visitor

Does a value (Text or number VS text or number) exist in another table?

In table 2, I am trying to figure out if a JOB ID exists in Table 2 before I continue with a switch funtion.

 

Basically I first need to test and see if a value from a JOB ID column in Table 1 exists in the JOB ID column in Table 2 - How would I do this?

 

Table 1:

JOB ID | Found in Table 2?

text          NO

08            NO

09            YES

10            YES

11            YES

12            YES

 

Table 2:

JOB ID

09

10

11

12

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Ronniemaccagee , In the case of tables are not related to job ID as 1 to M

 

if(isblank(countx(filter(Table2,Table1[JOB ID] =Table2[JOB ID]),Table2[JOB ID])),"No","Yes")

 

If Table2 is on one side of 1 to M

 

if(isblank(related(Table2[JOB ID])),"No","Yes")

 

In case there is data type diff between join id

if(isblank(countx(filter(Table2,Table1[JOB ID]&"" =Table2[JOB ID]& ""),Table2[JOB ID])),"No","Yes")

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Ronniemaccagee , In the case of tables are not related to job ID as 1 to M

 

if(isblank(countx(filter(Table2,Table1[JOB ID] =Table2[JOB ID]),Table2[JOB ID])),"No","Yes")

 

If Table2 is on one side of 1 to M

 

if(isblank(related(Table2[JOB ID])),"No","Yes")

 

In case there is data type diff between join id

if(isblank(countx(filter(Table2,Table1[JOB ID]&"" =Table2[JOB ID]& ""),Table2[JOB ID])),"No","Yes")

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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

Top Solution Authors