Forum Discussion
Solved
Lookup a value within a table
I have a table in Power BI which looks similar to below (unable to post the actual table as this contains confidential information). Essentially it collates all of the different logins/user names fro...
Hopefully this would work
Column =
VAR mytable =
SUMMARIZE ( Table1, [Full Name], [Email] )
VAR mymanager = Table1[Manager Name]
RETURN
LOOKUPVALUE ( [Email], [Full Name], mymanager )Thanks for this, however I get an error;
A table of multiple values was supplied where a single value was expected.
TeamManagerEmail = VAR mytable=SUMMARIZE('DV_STAFF2:DV_STAFFBY_EMPNO',[FullName],[SageEmailAddress]) VAR mymanager='DV_STAFF2:DV_STAFFBY_EMPNO'[Team Manager] RETURN LOOKUPVALUE([SageEmailAddress],[FullName],mymanager)The only difference between mine and yours is the '' marks around the table name.
Any suggestions?
As mentioned here, if multiple rows match the search values and in all cases result_column values are identical then that value is returned. However, if result_column returns different values an error is returned.
