Forum Discussion

Abbi's avatar
Abbi
Icon for Helper I rankHelper I
4 years ago
Solved

How to Compare two columns from 2 different tables

Hi ALL,   Hope every one is doing well. Need your help in comparing 2 columns from different tables. Putting down my sample data. Table 1 : ID Depedency 1234 Client 1234 Testing 1...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Abbi here you go https://www.dropbox.com/t/x3YgD9Jf7DsM58i6

    Code for Table 1 remains the same. Code for table 2 is updated as follows

    T2 Dependancy = 
VAR MissingItems = EXCEPT ( Table2, Table1 )
VAR Result =
IF (
    HASONEVALUE ( Append1[ID] ), 
    CONCATENATEX (
        MissingItems,
        Table2[Depedency],
        "," & UNICHAR(10)
    )
)
RETURN
    Result


    If I solve your problem please consider marking my reply as Accepted. Liks (Kudos) are also appreciated.
    Thank you