LOOKUPVALUE

Syntax

LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value>[, <search_columnName>, <search_value>]…)

Tutorial with example

EXAMPLE 1

In todays DAX Friday video, we will learn how to use the DAX Function called LOOKUPVALUE:
Lookupvalue is very similar to excel’s VLookup but there are some critical differences that you need to understand if you want to use it.
We will have two scenarios,:
Scenario 1: we will do a lookupvalue with two tables using two reference columns and
Scenario 2: We will do a lookupvalue between three tables, where one of the tables has the key between the rest.

Link to the Dutchdatadude blog: http://www.dutchdatadude.com/power-bi-pro-tip-lookupvalue-function/

Download example file:

Link to Power BI file: here.

EXAMPLE 2

In today’s video we will deconstruct a measure that was created by a microsoft employee in the Power BI community:

Link to the Power BI community post: https://community.powerbi.com/t5/Desktop/Calculate-duration-based-on-dates-in-different-rows/td-p/58886

In this video we will go also through the functions:
05:56 LOOKUPVALUE
09:12 DATEDIFF and
How to calculate the difference between two dates in the same column in Power BI.

Remarks

The value of result_column at the row where all pairs of search_column and search_value have a match.

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

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