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.
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
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
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]) )
![ประสบการณ์ จ้าง Developer ที่ผมจะไม่มีวันลืม [ภาค2]](http://i.ytimg.com/vi/pZbsSDRrmXA/mqdefault.jpg)
Thank you sir, first time needed to know how to do lookup. Very easy to follow. I've subscribed. Thanks from Melbourne Au.
Awesome, thank you!
Easy way of Understanding all Functions. Thanks Sir
You are welcome
Great sir ,cover every topic in dax .great learing
Keep watching
does lookupvalue dax works in the same table?
Hi thanks for lookupvalue lesson but I am getting an error "A table of multiple values was supplied where a single value was expected."
Watch video again
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.
Check the datatype of lookup columns and also multiple matches
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
Not sure what worked for you.
Join the telegram group ask your question there someone may help
@@AnalyticswithNags Hi sir, please send telegram link.
Is there an equivalent way to do this within Power Query (in Datamart)?
Thanks keep learning share this channel with friends and colleagues
Is there similar DAX formula for HLOOKUP?
Not sure
CAN WE USE TREAT AS?
Both are different functions.
can we use related function for this case?
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
How to handle if we have multiple values then?
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]) )
@@AnalyticswithNags Thanks Nag for the detailed explanation
very useful... thank you!
Thanks keep learning share this channel with friends and colleagues
Hi Sir How can I use partial match in power bi like excel.
You can use containsstring or search Dax functions
@@AnalyticswithNags ok sir
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.
No trainings. Watch career guidance playlist