Please Add "Running Total In" Quick Calc to the Matrix

[jhonatan_carden]

Is important to add more Quick Calcs to the Matrix to have similar capabilities like quick calcs in excel pivot tables .I can use YTD function to calculate cumulative sum when I work with dates but when I work with categories without dates and also I want to do a cumulative sum from a created measures and not from a column of the table.

[jeffrey_fonten1]

Let's get organized on this - I see 4 or 5 versions of this request - I've voted here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11037546-running-total-calculations-e-g-in-line-charts

[a-frmeie]

This is by far not comple as you can only see aggregation by default sort of the category. If you want to use the running total descending by Revenue (or any other Measure) it does not work 😞

[powerbi-hvs]

URGENT Microsoft, please create the function of Running totals in the Dashboard, it is a presentation function, not data nor Dax. Not having a running total in the Dashboard is a Nock Out critieria in the selection of BI tools.

[D7C2]

This is how you do it in SQL:

SUM(X) over(partition by Y order by XY) as Cumulative_SUM

Boom.

Try an internet search for that, it's a 20 minute Youtube video.