Forum Discussion
Solved
Accumulated sum goes wrong
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 = CAL...
I achieved this with:
ACCUMULATED = TOTALYTD([Boxes Sold],Calendar[Date])
Are you expecting the result to look like...
How did you do it?
I used
CALCULATE(
SUM(VentaProductos[Cajas Vendidas]),
FILTER(ALL(VentaProductos), VentaProductos[Fecha de aceptacion] <= MAX(VentaProductos[Fecha de aceptacion]))
)