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.