Forum Discussion
Dynamically joining distinct nested tables based on a common column
Hi guys, I am working on a dataset where I want to combine multiple nested tables into one big table. The nature of the nested tables are in the attached screenshots below; each nested table con...
not completely clear what you want, but I would try this strategy:
1) expand the column of tables
2) group the data of the large table obtained on the Unique column and choose not to aggregate on any column but to keep all the rows.
If you attach a file with some dummy tables I can write you the single steps in detail.
I now have a sample dataset but not sure how to upload it here. Any thoughts? Thank you.
Hi JohnFonz
You can refer to this blog https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Best Regards,
Community Support Team _ Jing