Forum Discussion
Custom expanding rows based on other table data
Hi emmawdmi22
Assume your original tables are like below,
Is this what you want to have in a new table?
You can download the attached pbix at bottom to see detailed steps for the third table. I use Merge queries as new feature to create the new table.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi emmawdmi22
Assume your original tables are like below,
Is this what you want to have in a new table?
You can download the attached pbix at bottom to see detailed steps for the third table. I use Merge queries as new feature to create the new table.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
This works perfectly! Thank you so much for your help!
