Forum Discussion
Why this LOOKUPVALUE does not work?
Hello Can you tell me please why this LOOKUPVALUE in a calculated column in Table1 does not work? LOOKUPVALUE('Table2'[Column3],'Table2'[Column1],Table1[Column1]) Error: A table of multiple val...
Anonymous
the reason - you have more the one coincidence
you need to define business rule what exactly row whould be chosen for these cases
Hi, do you mean there are duplicates in these columns? And I need to specify which one to consider? How can I specify that?
Anonymous
yes
you have more than ine result resulted by your condition. you should define what result to choose. MAX() or MIN() or AVERAGE or FIRSTNONBLANK. there is a lot of possible solutions depending on your logic. you can create a column like
CALCULATE(FIRSTNONBLANK('Table2'[Column3], 1), FILTER(ALL(Table2), 'Table2'[Column1] = EARLIER(Table1[Column1]) ) )