Forum Discussion
Solved
How to get first value from multiple value LOOKUPVALUE function
Is it possible to get just one value from a multi-value LOOKUPVALUE result? (i.e., is there another function that can handle this?) I have a table (Table1) that contains rows with non-unique ID v...
Okay, NickolajJessen, with your help (and similar threads on this community), I have this solution:
LOOKUPALT = CALCULATE(FIRSTNONBLANK(Table1[Value2], TRUE()), FILTER(Table1, Table1[ID] = Table2[ID]))
Okay, NickolajJessen, with your help (and similar threads on this community), I have this solution:
LOOKUPALT = CALCULATE(FIRSTNONBLANK(Table1[Value2], TRUE()), FILTER(Table1, Table1[ID] = Table2[ID]))
Love this. Thank you. Question: can you think of any lower processor intensive ways to do this for big tables? Maybe innerjoin somehow?