Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Lookup value based on multiple criteria.

hi guys,    I have this formulated column to gather some values from a table into another depending on a single criteria:   Last AIF VA MCLS = calculate(FIRSTNONBLANK('Last Observation VA Mcls'[A...
Need Help
Show and Tell
hmt1's avatar
hmt1
Frequent Visitor
3 years ago

For anyone else that ended up here, LOOKUPVALUE lets you keep adding search columns and search values.

 

LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value> [, <search2_columnName>, <search2_value>]… [, <alternateResult>] )