look up value A table of multiple values was supplied where a single value was expected

[viveksairam89]

Hi,

look up value in employee table of multiple values was supplied where a single value was expected. how to resolve

objective is to create a new column and find manager id using emp id and manager name,

below sample table:

Emp id	Employee Name	Manager Name	dept	email
1	vivek	kholi	batting	vivek1@abc
2	vivek	raina	fielding	vivek2@abc
3	John	vivek	bowling	john@abc
4	vivek	dhoni	allrounder	vivek3@abc
5	kholi	dravid	batting	kholi@abc
6	raina	dravid	fielding	raina@abc
7	dhoni	dravid	allrounder	dhoni@abc
8	dravid		allrounder	dravid@abc

Tryed to achieve in power bi using emailid to look up for manager value

[amitchandak · Accepted solution]

@viveksairam89 , You can try like

Maxx(filter(Table, Table[Employee Name] = Earlier(Table[Manager Name]) ), Table[email])