Forum Discussion
Copy column from one table to another table
Hi, I am trying to copy the value from a column (self) from a table called GetIssues to another table called 49407. I created a new column called Self in 40407 and I tried to use LOOKUPVALUE but...
Hi Anonymous ,
One sample for your reference, please check the following steps as below.
1. Insert index column in both table in power query.
2. Close and apply, then we use the LOOKUPVALUE to get the excepted result.
Self in 40407 = LOOKUPVALUE(GetIssues[Self],GetIssues[Index],'49407'[Index])
For more details, please check the pbix as attached.
Hi Anonymous ,
merge This should help you.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
How to do this in Power Query ( Without using append or merging & DAX?)