Forum Discussion
comparing multiple values in two columns and displaying unique and matching values
Hi Anonymous
For the ones present in the first but not on the second column, create a new, one-column calculated table:
NewTable = EXCEPT ( DISTINCT ( Table1[Coulmn1] ), DISTINCT ( Table2[Coulmn2] ) )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Anonymous
The unique values are from the first table in the EXCEPT( )
EXCEPT(Table1, Table2 ) gives you the values that are present in Table1 but not present in Table2. You can simply do
EXCEPT(Table2, Table1 ) if you want the values present in Table2 but not present in Table1
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
AlB Thank you for the attached file, It worked, the only issue now is that I do not know if the unique values are from table 1 or table 2, hopefully that works when I sync the slicers from those tables.Thank you.
Kind Regards,
Shlok Shah
Community ChampionAnonymous
The unique values are from the first table in the EXCEPT( )
EXCEPT(Table1, Table2 ) gives you the values that are present in Table1 but not present in Table2. You can simply do
EXCEPT(Table2, Table1 ) if you want the values present in Table2 but not present in Table1
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers