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

[Ronniemaccagee]

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

[amitchandak · Accepted solution]

@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")