LOOKUPVALUE in PowerQuery

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

  1. erotik says:

    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

  2. Zora says:

    Thanks for finally talking about > LOOKUPVALUE in PowerQuery – Power BI
    Ninjas < Liked it!

  3. 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.

  4. steam iron says:

    I am not really fantastic with English but I find this real easygoing to interpret .

  5. Jc Saephan says:

    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!

Leave a Reply

Your email address will not be published. Required fields are marked *