Forum Discussion
Solved
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...
M Code
NewStep=let a=Table.Buffer(Table.Group(WorkDay,"EmployeeID",{"n",each 1})) in Table.SelectRows(PCPros,each a{[EmployeeID=[EmployeeID]]}?<>null)
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)
Thank you!