Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
andreazambon
Helper V
Helper V

Show a table with values not included in another table

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
1 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. 😉

View solution in original post

2 REPLIES 2
NaveenGandhi
Super User
Super User

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!!

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. 😉

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.