Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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
Solved! Go to 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")
@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")
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
107 | |
68 | |
48 | |
44 | |
44 |