Cumulative Column in a Query Model with Virtual Tables

CupidC ,

Try a new column

Sumx(filter(Table, [Value] <= Earlier([Value]) ), [Value])

Hi Amitchandak,

Thank you! It's working perfectly. I have another question: is there a possibility to use a variable instead of using  Earlier? I've come across several posts recommending against this function and was wondering if there's an alternative method involving variables or something else..  thanks!

Thanks

Cupid

Hi CupidC ,
You can try this

DemoTable = 
VAR vTable =
    DATATABLE (
        "Index",INTEGER,
        "Name", STRING,
        "Value", INTEGER,
        {
            { 1,"A", 1 },
            { 2,"A", 2 },
            { 3,"A", 3 }
        }
    )
VAR vAddRT =
    ADDCOLUMNS (
        vTable,
        "RT",
            VAR thisrowindex = [Index]
            RETURN
                SUMX ( FILTER ( vTable, [Index] <= thisrowindex ), [Value] )
    )
RETURN
    vAddRT

Final output

Best regards,

Albert He

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