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...
Anonymous Try this, PBIX attached below signature.
Passed? = IF( TRUE IN SELECTCOLUMNS( RELATEDTABLE( 'Table 2' ), "__Passed", [Passed?] ), TRUE(), FALSE() )
Anonymous Try this, PBIX attached below signature.
Passed? = IF( TRUE IN SELECTCOLUMNS( RELATEDTABLE( 'Table 2' ), "__Passed", [Passed?] ), TRUE(), FALSE() )Amazing it worked, thanks 😃