jhonatan.cardenas on 13 Jul 2016 05:44:42
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.
- Comments (4)
RE: Please Add "Running Total In" Quick Calc to the Matrix
This is how you do it in SQL:SUM(X) over(partition by Y order by XY) as Cumulative_SUMBoom.Try an internet search for that, it's a 20 minute Youtube video.
RE: Please Add "Running Total In" Quick Calc to the Matrix
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.
RE: Please Add "Running Total In" Quick Calc to the Matrix
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 :-(
RE: Please Add "Running Total In" Quick Calc to the Matrix
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