Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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. 😉
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |