Show a table with values not included in another table

[andreazambon]

Hi there, 

I have a table (call it Table1) where I have some product IDs.

Suppose to have another Table (Table2) where I have some IDs of Table1, but I don't have all of them.

I need to show the elements of Table1 that are NOT presents in the Table2. What kind of join do you suggest in this case?

Ex Table1: 

ID1

ID2

ID3

ID4

ID5

Ex Table2:

ID1

ID3

ID5

Resul table:

ID2

ID4

[NaveenGandhi]

Hello @andreazambon 

Try the below Dax to create the table.

T3 = EXCEPT(t1,t2)

Let me know if this helps!

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

[andreazambon · Accepted solution]

Hi @NaveenGandhi , 

Actually I don't like to create table in DAX language because I wouldn't see them in powerquery. 

I got it: 

In powerquery, I Merge as a new table T1 and T2 using Left Anti Merge. This way, the new table is composed only by rows that appears in T1 and not in T2. 😉