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.
Let us know your thoughts...