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.
Hi All,
I feel like this should be simple but just can't figure out the right approach. I have calculated a running total per rank (not using dates but sprints in an Agile project) successfully. However I would now like to calculate the running total for completed or "Done" i.e. by status.
I think for step one I need to calculate the total points per Sprint filtered by "Done" status as a calculated column probably using the calculate function. I have tried the following from other forums:
Points | Sprint | Sprint total WPs | Completed points |
4.7 | 0 | 994.45 | 628 |
4 | 0 | 994.45 | 628 |
2.7 | 0 | 994.45 | 628 |
1.35 | 0 | 994.45 | 628 |
5.4 | 1 | 9.5 | 628 |
3.1 | 1 | 9.5 | 628 |
1 | 1 | 9.5 | 628 |
3.4 | 2 | 12.4 | 628 |
2 | 12.4 | 628 | |
4 | 2 | 12.4 | 628 |
4 | 2 | 12.4 | 628 |
1 | 2 | 12.4 | 628 |
3 | 4.7 | 628 | |
1 | 3 | 4.7 | 628 |
0.5 | 3 | 4.7 |
Would love some help!
thanks
Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |