Forum Discussion
lookupValue in the same table
Hi All, I am trying to populate a column (Manager ID) using the Lookupvalue but getting error mesage that says "A table of multiple values was supplied where a single value was expected."...follo...
Hi,
You can use this DAX:
Manager ID = LOOKUPVALUE('OrgChart_Raw'[Employee ID],'OrgChart_Raw'[Name],'OrgChart_Raw'[Manager Name])If this helps, I apreciate you give a kudo and mark as the solution. Thanks
ChrisMendoza
Resident Rockstar
Resident RockstarAnonymous -
Is [Manager Name] ever going to be equal to [Employee Name]? I would take a look at https://www.daxpatterns.com/parent-child-hierarchies/ to handle something like this.
Hi ChrisMendoza , yes in the employee column I have all the employees in the organization including the manager, I just want to create a Manager ID column beside manager name column, and all the IDs are in the Employee ID column. I can do it in excel using the vlookup function but wanted to see if this can be done in Power BI.
Thanks