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_IAM&OES'[Value], 'Append_Direct Ohds_IAM&OES'[Month], Sales_Data_Master[MonthV2], 'Append_Direct Ohds_IAM&OES'[Year], Sales_Data_Master[Years_In_Date], 'Append_Direct Ohds_IAM&OES'[Channel], Sales_Data_Master[Channel], 'Append_Direct Ohds_IAM&OES'[Country], Sales_Data_Master[Sales_Country], 'Append_Direct Ohds_IAM&OES'[Type of Cost], "4.Purch")

 

Happy to Provide Sample data if required... 

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.

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    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.