Forum Discussion
To Match Records between two Tables
I have two tables with data as shown below
Here I want to find the code in Column D of Table 2 from Column A in the Table 1 and pull the amount (Column B) and record that amount against matching record in Column F of the Table 2. Kindly advice me how to solve this issue
Hello Upali63 ,
Firstly clear the description which is ColumnA in Table 1 in Power Query Editor using Split Columns and Trims combination as per your text requirement.
Then create relationship between these two table to get the data and if relationship does not work because of Many to Many relationship then create a bridge table to use the same.Another way is you can use LOOKUPVALUE DAX function as well depends upon the duplicacy in the data.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
1 Reply
Hello Upali63 ,
Firstly clear the description which is ColumnA in Table 1 in Power Query Editor using Split Columns and Trims combination as per your text requirement.
Then create relationship between these two table to get the data and if relationship does not work because of Many to Many relationship then create a bridge table to use the same.Another way is you can use LOOKUPVALUE DAX function as well depends upon the duplicacy in the data.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!