Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

TRICKY - Power Query Lookup

Hi Experts   Is it posssible to move the following measure to a Custom Column in Power Query and how would you do it - Steo by Step guide for learn... LookupCost = LOOKUPVALUE( 'Append_Direct Ohds...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

     

    In my opinion, I think you can try to use the merge query function.

    Please check the below for the merge query function in Power Query Editor.

     

     

    1 Select the table that you want to pull data into.

    2 click

    3 select the table that you want to lookup the value

    4 select the column that you want to match

    5 select the column that you want to match -> in step four, when you select multiple columns the numbers are shown. you also have to match these numbers with step five.

    6 click

     

    I hope it helps.

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster.