• Skip to main content
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Data Stories
    • Power BI Stories
    • 1 dataset, 100 matplotlib visualizations
  • Learning Portal
    • Download Center
    • 25 Days Challenge
    • DAX Glossary
    • Power BI
    • Power BI by Topic
    • Python
    • 1 dataset, 100 matplotlib visualizations
  • Courses
    • Power BI Mini Master Class 1: Using a REST API as a data source
    • Power BI Master Class 1: COVID Tracker
    • Introduction to Power BI – FREE Online course
    • M Language + Power Query Course Bundle
    • Power Query Online Training [updated 2022]
    • M Language Online Course: The unofficial and Practical Reference Guide [updated 2025]
    • My Courses
  • Shop
    • Courses
    • Master Classes
    • Template Apps
    • JSON Themes
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Search
  • Contact
You are here: Home / CM Tooltip Glossary Pro+ / LOOKUPVALUE

LOOKUPVALUE

posted on October 5, 2017

« Back to Glossary Index

Syntax

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

Tutorial with example

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/

DAX Fridays! #41: LOOKUPVALUE with multiple columns

Download example file:

To get the files:
1. Go to Curbal Download Center > Dax Fridays
2. Get File #41

Example 2: Understanding LOOKUPVALUE errors

Have you got the following error when using the DAX function LOOKUPVALUES?
“A table of multiple values was supplied where a single value was expected”
In this video, I will show you why that error happens and what you need to do to resolve it and use the function as intended.

DAX Fridays! #90: Understanding LOOKUPVALUES error

Example 3: Deconstruct a DAX measure

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

DAX Fridays! #54: Reverse engineer/ Deconstruct a DAX measure

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.

Was this helpful?
See Also:
  • DATEDIFF
« Back to Index

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer CTA

Join our community of +50,000 professionals

Become a Member

Subscribe to YouTube

About me:

Curbal AB
Badhusgatan 7B
722 15 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2025 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In