Forum Discussion
Find & List Unique Values Between Two Columns
You can create a new table with:
Table = EXCEPT( values( Table1[Column1]), values( Table1[Column2] ))
Depending on your goals, you could also just use that a table function in a measure, so that it's only called when used.
Also could do this in powery query
I should have mentioned this previously, I generated/calculated Column A & B from a parent column (Column C).
Is there a way to show the unique values between A & B without creating tables seeing as Column A & B are calculated columns?I dont see why not. Any chance you upload some sample data?
See below for a sample of the data and my steps as they currently are.
Step 1. Create two calculated
Calculated Column 1 - List values that appear in 2018
Calculated Column 2 - List values that appear in 2019
Step 2 (The Issue). How to reference the two calculated column lists to show what values have appeared in 2018 but not in 2019 yet.
Data Example:
Value Year B9689 2018 H40019 2018 H40019 2018 H40019 2019 J0190 2018 M3500 2018 M3500 2018 M3500 2019 M4127 2018 M4127 2019 M5136 2018 M8580 2018 N202 2018 N390 2018 Z0000 2018 Z23 2018 Z6823 2018 Z6824 2019 B349 2018 A084 2018 M25511 2019 M25511 2019 M25561 2019 Z1211 2018 W19XXXA 2019 H40003 2019 E782 2018 E782 2019 M7581 2019 Z87442 2018 Z87442 2019
