Forum Discussion
Solved
Match id and create a new table
Dear community, Please have a look at this pbix: https://ufile.io/7kcqtsrm At the main table, the ConsolID is unique. While in SubTable, the ConsolID is duplicate since there have many shipment ...
Hi NickProp28 ,
You could use Merge Queries as New feature in Query Editor to create a merged table then remove the unnecessary columns.
https://docs.microsoft.com/en-us/power-query/merge-queries-overview
Best Regards,
Jay
Hi NickProp28 ,
You could use Merge Queries as New feature in Query Editor to create a merged table then remove the unnecessary columns.
https://docs.microsoft.com/en-us/power-query/merge-queries-overview
Best Regards,
Jay