TRICKY - Power Query Lookup

[Anonymous]

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

[Jihwan_Kim · Accepted solution]

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.

[amitchandak]

@Anonymous , refer if these couple of articles can help

https://eriksvensen.wordpress.com/2019/02/28/powerquery-replicate-doing-an-excel-vlookup-in-m/

https://www.myonlinetraininghub.com/excel-power-query-vlookup

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

I think@ImkeF can help with this.