How to calculate the running total in column

[naoyixue1]

Hey all,

I treid to add the column of running total to identify items ranking. The left side is the original table. Since I could not add there, I applied the summarize function to create the new table and calculate that in the new summarize table. Just out of curiousity, do you know how I can calculate the cululative column in the original table . (see details as attached) 

[Anonymous · Accepted solution]

Hi @naoyixue1 ,

You can create a calculated column as follows.

Cumulative% = var _table=SUMMARIZE('Original Table',[Item level %],[SKU])
return SUMX(FILTER(_table,[SKU]<=EARLIER('Original Table'[SKU])),[Item level %])

Best Regards,

Stephen Tao

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

[naoyixue1]

@Anonymous Thanks Stephen!

[naoyixue1]

@ribisht17 Thanks, Ritesh! Unfortunately, it doesn't work.

Hey all, any other thoughts? 

[ribisht17]

Please try https://stackoverflow.com/questions/40226792/how-to-calculate-cumulative-total-and-in-dax

Thanks,

Ritesh