Forum Discussion

Creative_tree88's avatar
Creative_tree88
Icon for Helper V rankHelper V
1 year ago

Grouping data from multiple tables

Hi all - I have had to import around 4 different tables, from different databases, into Power Query - linked them together, to be able to produce a lovely table which displays it perfectly.   Howev...
Need Help
v-priyankata's avatar
v-priyankata
Icon for Community Support rankCommunity Support
1 year ago

Hi Creative_tree88 
Thanks for your detailed explanation and diagram it was very helpful.

I’ve reproduced your scenario in Power BI Desktop using the multiple tables and relationships as you described. After merging the tables and grouping the procedures by session (sess_code), I was able to generate the combined procedure codes and names per session exactly as shown in your expected output.

To help you understand and reuse the solution, I’ve attached a sample .pbix file with all the steps applied including:

  • Table merging (via Merge Queries)
  • Grouping (using Group By → All Rows)
  • Custom columns for code and name combination
  • Final summary visual counting each combination


Output:

 



If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.