LOOKUP DAX Function (Filter)

Syntax  |  Return values  |  Related  

Identifies cells where specified columns match evaluated expressions, and retrieves a column value (only when a single cell is identified) or calculates an expression’s value from those matching cells.

Syntax

LOOKUP ( <Result_ColumnOrExpression>, <Search_Column>, <Search_Value> [, <Search_Column>, <Search_Value> [, … ] ] )

Parameter	Attributes	Description
Result_ColumnOrExpression		Specifies the column to retrieve a value from or an expression to evaluate over the identified cells where search_columns match search_values.
Search_Column	Repeatable	The column that contains search_value.
Search_Value	Repeatable	The value that you want to find in search_column.

Return values

Scalar A single value of any type.

The value of the column found, or the result of the expression evaluated in the matching cells.

Related functions

Other related functions are:

• LOOKUPWITHTOTALS

Last update: Apr 8, 2025   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

Microsoft documentation not available.
The function may be undocumented or unsupported. Check the Compatibility box on this page.