LOOKUPVALUE in PowerQuery
I love LOOKUPVALUE. It’s a great DAX function.
However, sometimes, it’s better for the column to be looked up in Power Query.
To bring in a column from another table, Merge your lookup table with your main table on the common key.
Here’s an example where I bring in the State Name into a table. I’m ‘looking up’ using a state abbreviation column.
Step 1: Merge Queries to bring in desired column.
Step 2: Merge. I’m Doing a Right outer join on the State Code Column to get my State Name.
Step 3: Expand column to bring in Desired Field
Step 4: Click OK and bring in desired column.
Here‘s a video example of how to do it.
#DAX #LOOKUPVALUE #POWERQUERY
6 Responses
Hey there. I found your web site by the use of Google even as looking for a comparable subject, your web site got here up. It seems to be great. I have bookmarked it in my google bookmarks to visit then. Kristan Everett Telford
Thanks for finally talking about > LOOKUPVALUE in PowerQuery – Power BI
Ninjas < Liked it!
Spot on with this write-up, I truly think this website needs much more consideration. I?ll probably be again to read much more, thanks for that info.
This really answered my problem, thank you!
I am not really fantastic with English but I find this real easygoing to interpret .
I’d have to check with you here. Which is not something I usually do! I take pleasure in reading a submit that will make folks think. Additionally, thanks for allowing me to remark!