Forum Discussion

rhcentennialh's avatar
rhcentennialh
Icon for Helper II rankHelper II
7 years ago

Find & List Unique Values Between Two Columns

I am needing to identify and then list unique values that have been captured in Column A but not in Column B on a separate column. This appears to be a simple process but for some reason i have not f...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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