Forum Discussion
Solved
Problems with formula for creating cumulative counts for a Task Burn-Up Chart
This appears to be a common question within this board and elsewhere on the internet...but having reviewed multiple posts, I'm still unable to do a calculation for cummulative task values for use in ...
Found the solution....
Cummulative Planned Finished Task Count = CALCULATE(sum('Project Schedule Burn-Up Weekly Count'[Weekly Planned Finish Task Count]), FILTER (ALLSELECTED('Project Schedule Burn-Up Weekly Count'[Period Week End]),'Project Schedule Burn-Up Weekly Count'[Period Week End] <= MAX('Project Schedule Burn-Up Weekly Count'[Period Week End])))
The formula that i'm currently using in Power BI Desktop (shown above in screenshot) is provided before for clarity and for easier viewing:
Cummulative Planned Finished Task Count = CALCULATE(SUM('Project Schedule Burn-Up Weekly Count'[Weekly Planned Finish Task Count]),'Project Schedule Burn-Up Weekly Count'[Period Week End] <= MAX('Project Schedule Burn-Up Weekly Count'[Period Week End]))