Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
OscarSuarez10
Helper III
Helper III

Sum total production per Year incluidin all products

Hello How can I use power query to sum the total production per year including the production of each prouduct , as in the following table ?

 

YearPRODUCTTOTAL PRODUCTION TOTAL PRODUCTION PER YEAR
2019A10 2019212  
2020A50 2020115  
2021A60 2021130  
2022A78 2022261  
2023A60 2023594  
2024A10 202484  
2025A456 2025476  
2019B123     
2020B20     
2021B50     
2022B60     
2023B78     
2024B64     
2025B10     
2019C79     
2020C45     
2021C20     
2022C123     
2023C456     
2024C10     
2025C10     
1 ACCEPTED SOLUTION
Anonymous
Not applicable

You can use GroupBy-->Groupby Year, Then aggregate by changing Operation to Sum and the column to Total Production. 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

You can use GroupBy-->Groupby Year, Then aggregate by changing Operation to Sum and the column to Total Production. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors