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?
Could you please share some sample file to have a test and post your desired result if possible?