Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 |
Solved! Go to 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. 😉
Hello @andreazambon
Try the below Dax to create the table.
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. 😉
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
75 | |
68 | |
41 | |
35 |
User | Count |
---|---|
102 | |
56 | |
52 | |
46 | |
40 |