Forum Discussion
OscarSuarez10
Helper III
Helper IIICUMMULATIVE PRODUCTION PER PRODUCT
Hello, I need to calculate the cummultive production of some proudts by periods like in the following table, can you help me?
| Year | Product | Production | Cummulative Production |
| 1 | A | ||
| 1 | A | ||
| 1 | A | ||
| 1 | A | ||
| 1 | A | 10 | 10 |
| 2 | A | ||
| 2 | A | ||
| 2 | A | 20 | 30 |
| 3 | A | ||
| 3 | A | ||
| 3 | A | ||
| 3 | A | 30 | 60 |
| 1 | B | ||
| 1 | B | ||
| 1 | B | ||
| 1 | B | ||
| 1 | B | 15 | 15 |
| 2 | B | ||
| 2 | B | ||
| 2 | B | 10 | 25 |
| 3 | B | ||
| 3 | B | ||
| 3 | B | ||
| 3 | B | 5 | 30 |
You may use DAX below to add a calculated column.
Column = IF ( NOT ( ISBLANK ( 'Table'[Production] ) ), SUMX ( FILTER ( 'Table', 'Table'[Product] = EARLIER ( 'Table'[Product] ) && 'Table'[Year] <= EARLIER ( 'Table'[Year] ) ), 'Table'[Production] ) )
2 Replies
- parry2k
Super User
OscarSuarez10 use this DAX to get cummulative, change table and column name as per your model.
Cumm = CALCULATE( SUM( Cumm[Production] ), FILTER( ALLEXCEPT( Cumm, Cumm[Product] ), Cumm[Year] <= MAX( Cumm[Year] ) ) )
v-chuncz-msftCommunity Support
You may use DAX below to add a calculated column.
Column = IF ( NOT ( ISBLANK ( 'Table'[Production] ) ), SUMX ( FILTER ( 'Table', 'Table'[Product] = EARLIER ( 'Table'[Product] ) && 'Table'[Year] <= EARLIER ( 'Table'[Year] ) ), 'Table'[Production] ) )
