What is the best way to find the delta between two lists?

[Anonymous]

Hello

I have two lists/columns from different tables.

I want to easily see which values exist in one list and not the other and vice versa.

How can I do that?

Thanks!

[Greg_Deckler]

@Anonymous - Use the EXCEPT function

[Anonymous]

@Greg_Deckler  thanks but an example please?

[Greg_Deckler · Accepted solution]

@Anonymous 

Table = EXCEPT(DISTINCT('Table1'[Value]),DISTINCT('Table2'[Value]))

There is also an example in the official documentation:

https://docs.microsoft.com/en-us/dax/except-function-dax