Forum Discussion

newpbiuser01's avatar
newpbiuser01
Helper V
2 years ago
Solved

Flag Matching Rows in Different Tables

Hello,   I am trying to flag rows with matching values in two different tables. As an example, I have two tables, Table1 with a list of items, and some reference data tied to the items. Table2 is a...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi newpbiuser01 ,

     

    You can create a measure.

    Result = IF(MAX('Table1'[Item]) in VALUES('Table2'[Item]), "Yes", BLANK())

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi newpbiuser01 ,

 

You can create a measure.

Result = IF(MAX('Table1'[Item]) in VALUES('Table2'[Item]), "Yes", BLANK())

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

newpbiuser01's avatar
newpbiuser01
Helper V
2 years ago

Thank you Anonymous!