Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Comparing columns, marking duplicates

Good Morning, I have 2 tables, each has a column with a list of numbers and I am trying to compare the columns and show which numbers appear in both tables. The 2 tables have a M2M relationship so R...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous Try this. PBIX attached below signature.

    Duplicate = 
    VAR __Value = [Column2]
    VAR __Second = ALL('Table (2)'[Column2])
    VAR __Result = IF(__Value IN __Second,1,0)
RETURN
    __Result

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous Try this. PBIX attached below signature.

Duplicate = 
    VAR __Value = [Column2]
    VAR __Second = ALL('Table (2)'[Column2])
    VAR __Result = IF(__Value IN __Second,1,0)
RETURN
    __Result

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Greg_Deckler worked perfect, thanks!