Optional parameters for lookupvalue DAX

[ArulselvanD07]

Hi Team,

I am trying lookup a particular value in from my lookup table using optional parameters, meaning number of columns to lookup the data in lookup is going to vary based on the selected filters from another table. Is it possible to have optional parameters in LOOKUPVALUE DAX? Please clarify.

[v-yuezhe-msft · Accepted solution]

@ArulselvanD07,

It is not possible to use optional parameters in LOOKUPVALUE DAX as you describe. As stated in this article, both result_columnName and search_columnName parameters cannot be an expression.

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

Regards,
Lydia