Forum Discussion
cross reference data. between tables
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 🙂
Anonymous Try this, PBIX attached below signature.
Passed? = IF( TRUE IN SELECTCOLUMNS( RELATEDTABLE( 'Table 2' ), "__Passed", [Passed?] ), TRUE(), FALSE() )
2 Replies
Anonymous Try this, PBIX attached below signature.
Passed? = IF( TRUE IN SELECTCOLUMNS( RELATEDTABLE( 'Table 2' ), "__Passed", [Passed?] ), TRUE(), FALSE() )