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 

You can use DAX expression to create a new table like below.

 

yourTable = 
VAR a = TableA
VAR b = TableB
VAR ab = EXCEPT(a, b)
VAR ba = EXCEPT(b, a)
RETURN 
UNION(ab, ba)

 

Regards,
Mariusz

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