Help with cummulative totals

[YMiranda]

Hello, 

i've been trying to calculate a cummulative total within a date range  without any luck 

im trying to acchive something similiar to this (las column) 

1/31/2023	68,892.12	Last Net Position	181.75	a		68,892
1/31/2023	-68,492.00	Last Net Position	181.70	a		400
1/31/2023	-192.00	Last Net Position	180.95	c		208
1/31/2023	-160.00	Last Net Position	179.40	b		48
1/31/2023	-64.00	Last Net Position	177.90	Z		-16
1/31/2023	0.00	Last Net Position	177.40	d		-16

CALCULATE(

    SUM('V__NetDaily'[s70]),

    FILTER(

        ALLSELECTED('DIM_TIME'[Date]),

        ISONORAFTER('DIM_TIME'[Date], MAX('DIM_TIME'[Date]), DESC)

    )  

)

thanks in advance

se les agradece toda su ayuda

[Anonymous · Accepted solution]

Hi @YMiranda ,

Please have a try.

Add an index column in Power Query.

Then create a measure.

measure =
CALCULATE (
    SUM ( table[pos] ),
    FILTER (
        ALL ( table ),
        table[index] <= SELECTEDVALUE ( table[index] )
            && table[nom] = SELECTEDVALUE ( table[nom] )
    )
)

Finally you can filter the pos column is not blank.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.