How to compare value in two tables

[Anonymous]

Hello,

: 

I have made two summarized table.  Let's call them, Table1 and Table2.

In table2, I would like to add 4 new colums.

The purpose of the new colums is to compare row by row the following fields: OpportunityID, Amount1, Amount2, Amount3

So in the first new column, I would like to check if opportunityID in table1 =  opportunityid in table 2, if so, yes otherwise no.

For the second column, I would like to check if amount1 in table 1 = amount1 in table2, if so yes, otherwise no.  Same thing for column3 (compare amount2) and column4(compare amount3).

Does someone know how to do that?

Regards,

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

Would you please try to use the following measure:

Measure =

IF (

    MAX ( Table1[Amount1] )

        = LOOKUPVALUE (

            Table2[Amount1],

            Table2[opportunityID], MIN ( Table1[opportunityID] )

        )

        && MAX ( Table1[Amount2] )

            = LOOKUPVALUE (

                Table2[Amount2],

                Table2[opportunityID], MIN ( Table1[opportunityID] )

            )

        && MAX ( Table1[Amount3] )

            = LOOKUPVALUE (

                Table2[Amount3],

                Table2[opportunityID], MIN ( Table1[opportunityID] )

            ),

    "yes",

    "no"

)

Best Regards,

Dedmon Dai