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. 🙂

[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.

[ambillate]

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

[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!