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
Community ChampionYou've probably done something differently. Change the name of Column2 in table 2 to Column 1. Both columns in the expect should have the same name. From what I see there are no numbers in Table 2 present in Table1 in your example
See it all at work in the attached file.
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
- AlB
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