Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have found so many (solved) posts, but I haven't managed to translate it to my situation, so I hope someone will help me.
In table IW38 I want to add a column M_Planner
That new column should look in table IW38 column Plannergroup and match that value to table PlGrp column Code
and return the value in table PlGrp column Planner
Can someone write te Mcode for this?
Solved! Go to Solution.
Hi @IAM ,
You can add a custom column as below in the table IW38 in Power Query Editor, please find the details in the attachment.
= Table.AddColumn(#"Changed Type", "M_Planner", each PlGrp[Planner]{List.PositionOf(PlGrp[Code],[Plannergroup])})
In addition, you can refer the following blog to achieve it, there are two methods(merge method and add a custom column method) include in this blog.
VLOOKUP in Power Query Using List Functions
Best Regards
Hi @IAM ,
You can add a custom column as below in the table IW38 in Power Query Editor, please find the details in the attachment.
= Table.AddColumn(#"Changed Type", "M_Planner", each PlGrp[Planner]{List.PositionOf(PlGrp[Code],[Plannergroup])})
In addition, you can refer the following blog to achieve it, there are two methods(merge method and add a custom column method) include in this blog.
VLOOKUP in Power Query Using List Functions
Best Regards
@IAM , lookup in power query means merge the tables
https://eriksvensen.wordpress.com/2019/02/28/powerquery-replicate-doing-an-excel-vlookup-in-m/
Merge: https://radacad.com/append-vs-merge-in-power-bi-and-power-query
In the end, I merged my tables. This is the best way indeed 🙂
@IAM , Thanks for the update.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |