Forum Discussion
Find an item in a column and return a corresponding value?
Hi everyone
I'm trying to get the below table using power BI and struggling to get the column Supervisor ID using LOOKUPVALUE or the FILTER function. I have the employee name, employee ID, and Supervisor ID. I want to return the Supervisor ID by matching the employee name and supervisor name. Similar to index/match on excel. Thank you!
| Employee name | Employee ID | Supervisor Name | Supervisor ID |
| A | 1 | E | 5 |
| B | 2 | E | 5 |
| C | 3 | E | 5 |
| D | 4 | A | 1 |
| E | 5 | A | 1 |
2 Replies
- ChielFaber
Super User
You could add a custom column with the Text.Contains function wrapped in an if statement
- If(Text.Contains(employee‐name, supervisorname) = true then 1 else 0)
If you only want the rows with matched records you can now filter the new custom column.
