LOOKUP DAX Function
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. |
Last update: Jun 13, 2024 » 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.
2018-2024 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies