cross reference data. between tables

[Anonymous]

Hi, 

I would like to add a column in table 1 using data from table 2 to see if a company passed at least once 

So account 1 would be Passed

Account 2 passed 

Account 3 not passed 

Matching would be on account ID, I have tried LOOKUPVALUE but it does not let me as table 2 has double account ID's 

Table 1

Account ID	Company Name	Passed?
1	Company A
2	Company B
3	Company C

Table 2

Account ID	Date	Passed?
1	01-01-2024	FALSE
2	02-01-2024	TRUE
3	03-05-2024	FALSE
1	08-05-2024	TRUE
1	08-05-2024	FALSE
3	10-05-2024	FALSE

Any help would be appreciated 🙂 

[Greg_Deckler · Accepted solution]

@Anonymous Try this, PBIX attached below signature.

Passed? = IF( TRUE IN SELECTCOLUMNS( RELATEDTABLE( 'Table 2' ), "__Passed", [Passed?] ), TRUE(), FALSE() )

[Anonymous]

Amazing it worked, thanks 😃