To Match Records between two Tables

Question

I have two tables with data as shown below&nbsp;&nbsp;&nbsp;&nbsp;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.&nbsp; Kindly advice me how to solve this issue

kishore_kvn · Accepted Answer

Hello&nbsp;Upali63&nbsp;,
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.&nbsp;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.&nbsp;
Another way is you can use LOOKUPVALUE DAX function as well depends upon the duplicacy in the data.&nbsp;
&nbsp;
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

Forum Discussion

Related content

How to Count from two different table Un-matched record with New table

Table Merge creates duplicate records

Dynamically Expand Table Records

Counting Non-Blank Records

Stacked Records as a table