Скачать или смотреть Create Subtotals & Grand Total Easily in Power Query Challenge 88

In this Power Query tutorial, we tackle Challenge 88, where we efficiently create subtotals and a grand total for a dataset using the easiest approach—Table.Group. This method allows for quick aggregation without complex formulas or manual adjustments.

🔹 Topics Covered:
Using Table.Group to calculate subtotals per category
Adding a grand total row dynamically
Maintaining a structured and organized output
Best practices for summarizing data in Power Query

This approach is perfect for financial reports, sales summaries, and any dataset that requires structured aggregation.

Do you use a different method? Let me know in the comments! Don’t forget to like & subscribe for more Power Query solutions.

00:00 Introduction
00:45 Power Query Editor
02:35 creating the grand totals
04:30 Combine the tables