What is LOOKUPVALUE DAX function in Power BI? | LOOKUPVALUE() DAX | BI Consulting Pro | Power BI |

What is LOOKUPVALUE () DAX Function?
Returns the value for the row that meets all criteria specified by one or more search conditions.

In this video, I have explained everything about LOOKUPVALUE() DAX Function and its use cases.

For DA-100 Exam Tutorial Series:

************************
For more DAX Videos:
*************
For more Weekly Videos:
***********************************

********
LET'S CONNECT!
********

#LOOKUPVALUE() #DAXSundays #BIConsultingPro #PowerBI

-~-~~-~~~-~~-~-
Please watch: "Microsoft Azure Synapse Analytics Tutorial | Azure Synapse Studio |BI Consulting Pro |Azure Tutorial"
-~-~~-~~~-~~-~-

[BIConsultingPro]

Let us know if you have any concerns or questions?

[GSMonkey]

Thank you very much, tried reading about it, but your explanation is much easier to understand :) Wish i could give more than one like.

[Amitnehra]

You made my day with this video for lookup, god bless !!

[girishshenwai]

Sir in current scnario you have shown lookup value from single table if lookup value from state to country is 7 diffrent table and same is looked up in emp table who to do the same

[Trionyxification]

Clear and sound explanation. Thank you very much.

[nareshc]

Thank you brother for your video. It's helping me.

[muhammadpoonawala]

I want to pick a corresponding date which has the max sales value in a table
Pls give me the dax syntax
Thanx

[awesomebiskills]

Hi thanks for the dax lookupvalue lesson, but how do I deal with error "A table of multiple values was supplied where a single value was expected." in dax lookupvalue.

[esqueish]

Great explanation. Thanks for sharing.

[melissaphillips]

Thank you. Exactly the information that I needed.

[rupeshshelar]

how about 2 dimension table and one fact table where both dimension joined with fact table .. can we use lookup in 2 dimension table??

[renusharmadhoundiyal]

I have 4 pricing type 12 sales total - Contract, Standard, buyin, Override. We want to see sales impact by price increase 1%, 1.5%, 2% and so on. but want to exclude buyin and override from calculating but they should return 12 sales total without any increase.
So my total should be Contract, standard with price increase and Buying, override without price increase. I used calculate columns to use "If" and "switch"function but the result is not dynamic when i change % increase. pls help

[willbee]

Hmm; what if there is more than one Sales order? This example would seem to be good for going the other way; with an order number, looking up the customer number. I bet I'm missing something here; please help me understand this. Thank you. :)

[johnskilly]

Thank you for this... so well explained. I have a problem/question.... I have an output from a CRM that shows the accounts we work with and their activity in any given week/month/quarter. I also have a static account assignment list that shows us what we have assigned. What I want to see is, in any given time period what are the accounts in the CRM output that are active relative to the list of accounts assigned. Lookupvalue won´t work as I have no date to work with in that static account assignment list. What would be the best solution to this problem?

[sunriseankuram]

Useful video. How build relations between 2 tables? How to apply if & vlookup together in power bi?

[kevinmorneault]

hi how are you i have a question i am trying to write a statement with a is(isna(lookup which will return as an example found or notfound basically via the lookpup if we find the serial number it would say found if it does not find the serial it would say notfound i did try on statement but it was wit isblank so if its blank no if not yes the statement was the following if(isblank(lookup value(table a, table b, blank())), "no", "yes")
So what can we replace isblank with. As all field would have a serial and some may not

9

[powerbinoob]

i get this error "A table of multiple values was supplied where a single value was expected."

[andridarmawan]

How to countof woth another table reference?

[shwetkumar]

Sir without having a relationship lookup function can be used?

[shwetkumar]

Can we use it many to many relationships