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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.