Forum Discussion

Helper I

8 years ago

Solved

Cumulative Totals

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)

v-jiascu-msft

8 years ago

Hi BLM,

You need a measure like this:

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

Best Regards,

Dale

BLM

Helper I

8 years ago

hi v-jiascu-msft

I attached power bi archiv

example cumulativ

attached a example in power bi

v-jiascu-msft

Microsoft Employee

8 years ago

Hi BLM,

You need a measure like this:

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

Best Regards,

Dale