Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Only Show Duplicates between two tables

Hi,   Please, i have two tables, and i need to show only the lines that just exists in a only one.    Example:   Table 1: Name, ID, Function Table 2: Name, ID, Function   Then i have to show...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Mariusz,

     

    Thank you so much for the answer, i got it using the merge columns. There is an option that can show only the lines that exists in one of the columns.

     

    Best regards,

     

     

Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi Anonymous 

The below DAX will return only maching rows from both tables.

yourTable = NTERSECT(TableA, TableB)

Regards,
Mariusz

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
7 years ago

Hi Mariusz,

 

Thank you so much for the answer, i got it using the merge columns. There is an option that can show only the lines that exists in one of the columns.

 

Best regards,

 

 

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous ,

    Have you solved your problem?

    If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

    If you still need help, please share your data sample and your desired output so that we could help further on it.

    Best Regards,

    Cherry