Cumulative Totals

[BLM]

hello guys!!

I need an aummulative summ by date (only selected in slicer) and by another field (stock OPs). I attached a image for  show that I need. Thank you (sorry for my english)

[BLM]

I`m used this formula, but don`t work, summ all whitout date filter...

[BLM]

help me please...

[v-jiascu-msft]

Hi @BLM,

Can you share a dummy sample? It's hard to write a DAX formula without the data model.

Best Regards,

Dale

[BLM]

hi @v-jiascu-msft

I attached power bi archiv

example cumulativ

attached a example in power bi

[v-jiascu-msft · Accepted solution]

Hi @BLM,

You need a measure like this:

Measure =
CALCULATE (
    SUM ( movimientos[Cantidad] ),
    FILTER (
        ALLSELECTED ( 'calendar' ),
        'calendar'[fecha] <= MAX ( 'calendar'[fecha] )
    )
)

Best Regards,

Dale