Forum Discussion
Solved
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 fil...
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
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