Showing results for 
Search instead for 
Did you mean: 
Frenla02 Frequent Visitor
Frequent Visitor

Left Anti-Join not working correctly

I'm getting fairly proficent at PowerBI, but I do get stumped perodically. 


Here is the scenerio; I have two tables, one of all responders, and one is all responders who are currently assigned to a response. I am trying to build a table of all responders NOT assigned to a response. 


I tried using Merge Tables, and using Member Number and a Left-Anti Join to get just the list of responders who aren't on the "Currently Assigned" list. Which would seem to work, but then I can find names still on the merged list that are on the Currently Assigned List, and when I expand the merged columns, I find that they are all null, but when I look at the currenly assigned table, they are clearly filled in with information. 


I've tried comparing Member Number, and they are the same, and Merged by Name and still get the same result. I've even tried doing a full outer merge of the two tables and the Currently Assigned Table comes over will all "null" data. 


Why would the Currently Assigned table information not be tranferred over in the merge and filtered accordingly?

Community Support Team
Community Support Team

Re: Left Anti-Join not working correctly

Hi @Frenla02,

Could you please share some sample file to have a test and post your desired result if possible?



Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.