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 2 tables containing a list of parts, one from last month (Old, 165658 rows) and another from this month (New, 166761 rows). I want to do a right anti join so I can only display the rows from "New" that are different from "Old". So I go to the power query editor --> merge queries --> merge queries as new. See the image below:
Column 2 is the matching column, there are 165566 matches. The result is just a table of null values. (See the next image).
Could someone please tell me what I'm doing wrong?
Thanks!
Solved! Go to Solution.
You need to expand the table in the far right columns labeled "New".
You need to expand the table in the far right columns labeled "New".
Thanks!
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |