Help! Accumulated amount

[rod_puente]

Community

Pls your help, I need a funtion with CALCULATE, that allows me to accumulate by product code.

This is an example, dates can be repeated: ...the formula should be like the yellow column.

Regards

Rodrigo P.

[rod_puente]

Excelent!

Tkns tm.

Regards

Rodrigo P

[ryan_mayu]

you are welcome

[ryan_mayu · Accepted solution]

@rod_puente 

you can create an index column in PQ

then use DAX to create a column

Column = sumx(FILTER('Table','Table'[Codigo Producto]=EARLIER('Table'[Codigo Producto])&&'Table'[Index]<=EARLIER('Table'[Index])),'Table'[Cantidad])

pls see the attachment below