Cummulative production of different products at the same periods

[OscarSuarez10]

Hello I have to make the cummulative production of different productions at the same periods like this:

Year	Product	Production	Cummulative Production
1
1
1
1	A	100	100
2
2
2
2	A	200	300
3
3
3	A	300	600
1
1
1
1	B	20	20
2
2
2
2	B	30	50
3
3
3	B	40	90

Can you help me?

[v-juanli-msft · Accepted solution]

Hi @OscarSuarez10 

Create a measure

Measure = CALCULATE(SUM('Table'[Production]),FILTER(ALLEXCEPT('Table','Table'[Product]),'Table'[Year]<=MAX('Table'[Year])))

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ImkeF]

this article contains a DAX-solution as well as an M-solution for the query editor:

https://www.thebiccountant.com/2018/09/30/memory-efficient-clustered-running-total-in-power-bi/

[OscarSuarez10]

Thank You but I couldn´t finde the answer, I need a dax formula that can hep me to do this

[ImkeF]

Why do you post your question in the Power Query-section then?

Googling "Power BI running total" or "Power BI cumulative total" returns tons of articles and threads. And as you haven't posted anything specific about your request, I'd recommend you start there and come back with specific problems if theses posts cannot help you.