Copy paste specific rows from one table to another table based on matching value

[novicepowerbi]

Hi, 

I am very new to this. 

• I have 2 tables: 'Summary Table' and 'Details Table'
• There are cells from 'Details Table'[ACTIVITY ID] that match in 'Summary Table'[SUMMARY ACTIVITY CODE]
• I want to copy-paste the complete rows that have matching cells from 'Details Table' to 'Summary Table', but also insert the copied rows under the respective match.

Sample arbitrary data:

Desired outcome:

I am able to combine the two tables with only the rows with the matching cells but i cant insert them where I want to be automatically.

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

[novicepowerbi]

This does it for I need for now! Thank you so much!

[Ritaf1983]

Hi @novicepowerbi 
You can get the desired result by those steps :
1. merge details with summary table, by activity id :

after this step, you will have just needed rows from the details table, so you can delete the newly created column

next step is just to append the tables

result:

Note that you cant delete unnecessary table because of merge , so you can just not to load it to the model

Pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.