LOOKUPVALUE Function (DAX)

How does the LOOKUPVALUE function (DAX) work?

Returns the result_columnName value for the row that meets all of the search_columnnName and search_value criteria.

LOOKUPVALUE Formula Syntax

LOOKUPVALUE ( <Result_ColumnName>, <Search_ColumnName>, <Search_Value> [, <Search_ColumnName>, <Search_Value> [, … ] ] [, <Alternate_Result>] )

How do you use the LOOKUPVALUE function?

The value of result_column at the row in which all search_column and search_value pairs match.

Related Blog Posts

Related Support Forum Posts

Dynamic LOOKUPVALUE for multiple value combinations
LOOKUPVALUE in Direct Query Calculated Column
Costing Problem – LookupValue Use?

Considerations when using the LOOKUPVALUE function

If there is no match that satisfies all the search values, then a BLANK is returned. In other words, if only some of the parameters fit, the function will not return a lookup value.

If the search values match multiple rows, and Result Column values are identical in all cases, then that value is returned. If Result Column returns different values however, an error is returned.

The Search_ColumnName can be any column referenced by Result_ColumnName of the expanded table.

Related Video Tutorials

How To Use Virtual Tables With COUNTROWS in Power BI - DAX Formula Technique

Formula examples using the LOOKUPVALUE function

LOOKUPVALUE (
    ExchangeRates[Rate],
    ExchangeRates[Date], DATE ( 2018, 4, 15 ),
    ExchangeRates[Currency], “EUR”
)

LOOKUPVALUE (
    ExchangeRates[AverageRate],
    ExchangeRates[Date], DATE ( 2018, 4, 15 ),
    Currency[Currency Code], “EUR”
)

Related DAX Functions

RELATED
GROUPBY

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership