Power BI DAX Tutorial (17/50) - What is LookupValue Function

[@mikeycbd]

Thank you sir, first time needed to know how to do lookup. Very easy to follow. I've subscribed. Thanks from Melbourne Au.

[@AnalyticswithNags]

Awesome, thank you!

[@VinodKumar-zn8ty]

Easy way of Understanding all Functions. Thanks Sir

[@AnalyticswithNags]

You are welcome

[@llo.welc_me]

does lookupvalue dax works in the same table?

[@raviranjansingh5527]

Great sir ,cover every topic in dax .great learing

[@AnalyticswithNags]

Keep watching

[@awesomebiskills]

Hi thanks for lookupvalue lesson but I am getting an error "A table of multiple values was supplied where a single value was expected."

[@AnalyticswithNags]

Watch video again

[@flames0_official]

Hi nagi I am following the same step but getting blank values. column is been created measure also executed properly but no value is there inside the column.

[@AnalyticswithNags]

Check the datatype of lookup columns and also multiple matches

[@khandore]

Is there similar DAX formula for HLOOKUP?

[@AnalyticswithNags]

Not sure

[@justinma800]

Is there an equivalent way to do this within Power Query (in Datamart)?

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@theperpetuallyannoyed4074]

but my lookup table had multiple entries for but it still worked fine for me.. both the result values were multiple and search volume values were multiple as well but worked successfully... how

[@AnalyticswithNags]

Not sure what worked for you. Join the telegram group ask your question there someone may help

[@vinodhkumar9365]

@@AnalyticswithNags Hi sir, please send telegram link.

[@venkataranganadh7556]

CAN WE USE TREAT AS?

[@AnalyticswithNags]

Both are different functions.

[@sravani1191]

can we use related function for this case?

[@AnalyticswithNags]

No. Lookup used to get column from other table even though relationship doesn't exist. Where as the related function works only when there is relationship and will not get any value just activates the relationship

[@sandeepreddy7687]

How to handle if we have multiple values then?

[@AnalyticswithNags]

If you find duplicate entries and all your lookup values is same. You can still use this Lookupvalue function. If the Lookupvalue return multiple values you can't use the LOOKUPVALUE function. In that case you need to use CALCULATE ( FIRSTNONBLANK ( lookuptable[column], 1 ), FILTER ( ALL ( lookuptable ), lookuptable [referencecolumn] = basetable[reference column]) )

[@sandeepreddy7687]

@@AnalyticswithNags Thanks Nag for the detailed explanation

[@kishangzp]

very useful... thank you!

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@ArvindKumar-he4on]

Hi Sir How can I use partial match in power bi like excel.

[@AnalyticswithNags]

You can use containsstring or search Dax functions

[@ArvindKumar-he4on]

@@AnalyticswithNags ok sir

[@shivashankar1712]

Can I have number Please. I looking for Power Bi job. I wanted to learn more things on power bi. Will you provide training for Power BI.

[@AnalyticswithNags]

No trainings. Watch career guidance playlist