Accumulated sum goes wrong

[Syndicate_Admin]

Hello!

I have a "Product Sale" table with a "Total Boxes" column

I try to add the accumulated "Total Boxes" per month, I tried with the following function: but it goes wrong.

ACCUMULATED = CALCULATE(SUM(SaleProducts[Total Boxes]),

FILTER(ALL(VentaProductos),

SaleProducts[Date of acceptance]<=Max(SaleProducts[Date of acceptance])))

[Syndicate_Admin · Accepted solution]

I achieved this with:

ACCUMULATED = TOTALYTD([Boxes Sold],Calendar[Date])

[jgeddes]

How are you calculating Cajas Vendidas?

[jgeddes]

Are you expecting the result to look like...

[Syndicate_Admin]

How did you do it?

[jgeddes]

I used

CALCULATE(

SUM(VentaProductos[Cajas Vendidas]),
FILTER(ALL(VentaProductos), VentaProductos[Fecha de aceptacion] <= MAX(VentaProductos[Fecha de aceptacion]))
)

[Syndicate_Admin]

Yes, that's what I hope