Forum Discussion
Comparing Single Column in Two Tables
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?
M Code
NewStep=let a=Table.Buffer(Table.Group(WorkDay,"EmployeeID",{"n",each 1})) in Table.SelectRows(PCPros,each a{[EmployeeID=[EmployeeID]]}?<>null)
4 Replies
M Code
NewStep=let a=Table.Buffer(Table.Group(WorkDay,"EmployeeID",{"n",each 1})) in Table.SelectRows(PCPros,each a{[EmployeeID=[EmployeeID]]}?<>null)
That works! Thank you!
How do I change the query to pull only the EmployeeIDs that don't match?
NewStep=let a=Table.Buffer(Table.Group(WorkDay,"EmployeeID",{"n",each 1})) in Table.SelectRows(PCPros,each a{[EmployeeID=[EmployeeID]]}?=null)
