Need help: How to Exclude Row if the value Exist in another table

[ambillate]

Hi, Good Day.

I am a newbie here, 

Is it Possible to Exclude the Students that exist in Table 1?

Sample Desired Output:

Thanks a lot. 🙂

[stevedep · Accepted solution]

Hi @ambillate ,

This is one way to do it:

File is attached. 

Kind regards, Steve. 

[ambillate]

Hi @stevedep , thank you so much for helping me,  it really works.

and also to @rfigtree thank you. 🙂

[stevedep]

Glad to be of help!

[ambillate]

Hi, but I can't use transform data because I get data from Analysis Services. Thanks for your suggestion.

[rfigtree]

if you are willing to use power query (power bi, transform data).

that is what it does well.

select the type of join you want and the joining keys and all done. couple of mouse clicks.