I Need a Measure not a Power Query Formula - Accumulative column

Hi mhrkhader01 ,

You can try the next option:

Create these measures:

#Accum = 
VAR currentDate = SELECTEDVALUE ( T[Date] )
VAR sumAmt =
    CALCULATE (
        SUM ( T[Diff] ),
        FILTER ( ALLSELECTED ( T ), T[Date] <= currentDate )
    )
RETURN sumAmt

#AccumFiltered = 
VAR currentDate = SELECTEDVALUE ( T[Date] )
VAR firstDatValue = MINX ( ALLSELECTED ( T ), T[Date] )
VAR minValue = MINX ( FILTER ( T, T[Date] = firstDatValue ), T[Diff] )
VAR sumAmt =
    CALCULATE (
        SUM ( T[Diff] ),
        FILTER ( ALLSELECTED ( T ), T[Date] <= currentDate )
    )
VAR minOfSum =
    MIN (
        0,
        MINX ( FILTER ( ALLSELECTED ( T ), T[Date] <= currentDate ), [Accum] )
    )
RETURN
    IF (
        currentDate = firstDatValue && minValue < 0,
        sumAmt - minValue,
        sumAmt - minOfSum
    )

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

mhrkhader01 ,

You can use MAX instead of SELECTEDVALUE .

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