DAX Fridays! #41: LOOKUPVALUE with multiple columns

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.

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

ABOUT CURBAL:

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo

#daxfridays #curbal #SUBSCRIBE

[bradj]

"You don't need a relationship between tables when using the LOOKUPVALUE function, but you do when using RELATED." - most important piece. Love it! Thanks Ruth!

[officesuperhero]

EXACTLY what i was looking for. MIL GRACIAS!!

[keerthanUpadhyaa]

Dear Ruth.. I recently started working on DAX and Power BI (since about 2 weeks) but all my friends and colleagues think that I have intermediate level.. Crazy right!? :) all the credit goes to you and your beautiful videos. You are doing a fantabulous job!! I feel you are definitely almost at the center of your Ikigai.

[SmartBimson]

Very interesting video Ruth ! And I'll give the dutchdatadude a thumbs up as well 👍🏻 and now enjoy your weekend and see you soon 😉🙋🏼‍♂️🌞

[pabeader]

I know it's been a while since you did this video but I have a great use for this function. I have two tables that require the combination of two columns to make a unique selection. In my case both tables have Date and Machine. In each table, the Date, Machine combination identifies a unique row. By using Lookupvalue, I am able to get the value from table2 that I need as part of a calculated column in table1. Very much like your example for which I am grateful.

[sandraglove]

Thank you so much! you helped me to understand the formula and apply it into my data model.
DAX is very hard for a dummie like me,
Please don't stop uploading videos♥!

[loginraj]

very helpful.. it really made my day..

[TheAlexandersword]

Very helpful! I wonder if they will incorporate the xlookup design into the a new DAX variant of LOOKUPVALUE.

[daweiwang]

Thank you so much, you just saved my day! 非常感谢！🎉

[nsr]

Good one. Tried the scenario 1 in a different way. created a new column as JKEY in both tables as compound key.
JKEY = MarketShare[Company]&"-"&FORMAT(MarketShare[Date], "yyyymmdd") and
JKEY = StockValue[Stock]&"-"&FORMAT(StockValue[Date], "yyyymmdd") and created the relation ship on JKEY. (1:1). We can add multiple columns in jkey to make it unique and can be joined. Not sure why they limited the relationship to only a single column (:

[ViewerBot]

You are a POWER BI GODDESS! Thank you! THank you! THANK you !

[mathijs]

great tutorial.This you can use to dynamic calculate fgures in selected currency WITH date.

[julysantaschmus]

Thats so great! You know for what scenario i needed it? For Stock Value of different
companys : )
That solves it perfectly.. many many thanks! the best source to get solutions for anspecific dax problem = your channel!

[garymcbride]

Hi, you said in the video that you never use this function, with one exception. Can I ask what do you use instead? I’m creating a calculated column within which my formula looks up the mortality rate from a second table for people born In the main tables with the same year of birth and multiplies this mortality rate to another column in the main table. Would you not use this lookupvalue to do that? Thank you, great videos.

[neelkanthbk]

Thanks a ton for the wonderful video :)

[JaredTheStrange]

Really great! I was having errors using this and you led me to find a problem in my search value column. :)

[kevinlabore]

Thank you. This is just what I needed.

[saltsea]

how can I aggregate to a single value when I have multiple values returned?

[jacquelinelacan]

Back for some lindo DAX, thank you once again Ruth!

[saadhanif]

I am making an HR dashboard in power bi for which i want to lookup the department column of each employee which was updated recently from the Main table. Please advise what formula will i use alongwith lookup dax