Comparing Single Column in Two Tables

[thekeyjh]

I'm new to PowerBI and I have two tables that I am trying to compare named WorkDay and PCPros. Each table has a column titled EmployeeID.  I am trying to display all the rows in PCPros where there is a matching EmployeeID in WorkDay. Any idea how to do this in PowerBI/Power Queary Editor?

[wdx223_Daniel · Accepted solution]

M Code

NewStep=let a=Table.Buffer(Table.Group(WorkDay,"EmployeeID",{"n",each 1})) in Table.SelectRows(PCPros,each a{[EmployeeID=[EmployeeID]]}?<>null)

[thekeyjh]

That works! Thank you!

How do I change the query to pull only the EmployeeIDs that don't match?

[wdx223_Daniel]

NewStep=let a=Table.Buffer(Table.Group(WorkDay,"EmployeeID",{"n",each 1})) in Table.SelectRows(PCPros,each a{[EmployeeID=[EmployeeID]]}?=null)

[thekeyjh]

Thank you!