Power BI Lookupvalue – Defined With Examples

What is Lookupvalue in power BI ?

LOOKUPVALUE is a DAX (Data Analysis Expressions) function in Power BI that allows you to retrieve the value of a column in a table, based on the values of one or more columns. This function comes in handy when you need to perform lookups and obtain specific information from your dataset.

LOOKUPVALUE( <result_column>, <search_column>, <search_value> [, <search_column>, <search_value> [, ... ] ] )

<result_column> is the result value we want
<search_column> is the column you want to search in
<search_value> is the value by which we want to filter the search column.

The return type is Scalar(single Value).

Example:

For Example we are going to use Super_market dataset’s table ‘Product Lookup’.

Now we will create some measures with Lookupvalue in them

Lookup_example =
LOOKUPVALUE (
    'Products Lookup'[DESCRIPTION],
    'Products Lookup'[UPC], 1111009477
)

to view the result of the above measure you can use Card Visual in power bi and drag and drop measure into fields

To explain what is happening here, look at the picture below

Example 2 :

In this example we have two Search columns and values.

lookup_example2 =
LOOKUPVALUE (
    'Products Lookup'[DESCRIPTION],
    'Products Lookup'[MANUFACTURER], "QUAKER",
    'Products Lookup'[SUB_CATEGORY], "ALL FAMILY CEREAL"
)

To check the value use Card visual

Hope you now understand lookupvalue’s use.

READ MORE:
Power BI Treemaps
Power BI Lookupvalue

Thanks For Reading!