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.

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

Link to pbi file: https://curbal.com/blog/glossary/lookupvalue-dax

EXCEL SURVEY: https://1drv.ms/xs/s!Ar8CDNp8cGTcgjaHonN82T8I1jQT

PREVIOUS VIDEO: https://www.youtube.com/watch?v=kc7APFVM1PY
NEXT VIDEO: https://youtu.be/PoaQDakVI04
Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center

SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1

Our PLAYLISTS:
- Join our DAX Fridays! Series: https://goo.gl/FtUWUX
- Power BI dashboards for beginners: https://goo.gl/9YzyDP
- Power BI Tips & Tricks: https://goo.gl/H6kUbP
- Power Bi and Google Analytics: https://goo.gl/ZNsY8l

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: https://goo.gl/rvIBDP
► Facebook: https://goo.gl/bME2sB

#daxfridays #curbal #SUBSCRIBE
► Linkedin: https://goo.gl/3VW6Ky

Видео DAX Fridays! #41: LOOKUPVALUE with multiple columns канала Curbal