Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
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 = CALCULATE(SUM(SaleProducts[Total Boxes]),
FILTER(ALL(VentaProductos),
SaleProducts[Date of acceptance]<=Max(SaleProducts[Date of acceptance])))

6 Replies

      • jgeddes's avatar
        jgeddes
        Icon for Super User rankSuper User
        4 years ago

        I used

        CALCULATE(

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

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    4 years ago

    I achieved this with:

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