Forum Discussion
Copy paste specific rows from one table to another table based on matching value
- 2 years ago
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.
- 2 years ago
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
This does it for I need for now! Thank you so much!