cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

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

Accepted Solutions
Super User
Super User

Re: Sum total production per Year incluidin all products

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

1 REPLY 1
Super User
Super User

Re: Sum total production per Year incluidin all products

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

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 38 members 990 guests
Please welcome our newest community members: