Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
26
Views
Topic starter
I am needing to add a column in Power BI that shows a running total based on the line item % of Grand Total.
Below is what the output should look like:
% Of Grand Total | Running Total |
1.96% | 1.96% |
5.88% | 7.84% |
52.94% | 60.78% |
1.96% | 62.74% |
Posted : 17/04/2024 1:43 pm
Hi Ben,
Without the actual data I'm guessing as to what your data is. If you had dates in your table, you could do this with time intelligence functions.
Without them you need some sort of index to refer to the current row. In my example I've added an index column which allows me to sum up to and including that index using this
Running Total = CALCULATE(SUM('DataTable'[Value]), FILTER(ALL('DataTable'), 'DataTable'[Index] <= SELECTEDVALUE('DataTable'[Index])))
Download this PBIX file.
Regards
Phil
Posted : 17/04/2024 8:33 pm