Forum Discussion
Optional parameters for lookupvalue DAX
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.
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
1 Reply
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