Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am tring to aggregate data I have in a column by adding the data in the current row to all the previous rows. Sample data below shows the data in the Done column that I would like to aggregate to produce what I am showing in the Cumulative Done column:
Month | Done | Cumuluative Done |
January | 40 | 40 |
February | 40 | |
March | 1 | 41 |
April | 41 | |
May | 27 | 68 |
June | 67 | 135 |
July | 12 | 147 |
August | 49 | 196 |
September | 113 | 309 |
October | 115 | 424 |
November | 83 | 507 |
December | 507 |
For my data, the Done column is actually a calculated column based on counts of the number of items that have been moved to Done for the given month. The Cumulative Done column is to represent how many have moved to Done YTD.
How do I calculate the Cumulative Done in Power BI so I can show it in a line chart.?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |