Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 a burn-up chart.
I've used the following link as a primary reference...
https://www.youtube.com/watch?v=dMJLypl5HJg
The forumla referenced is shown below and appears at 4:08 within the video
And have tried to duplicate this formula within Power BI Desktop as noted below.
As presented within the screenshot... I have a prepared a table that includes weekly counts of planned and baseline finish counts. The table includes all dates (Column 2) ...irrespective of whether or not tasks are planned for that week (reference 0 values in columns 3 & 4).
Column 1 and the formula bar represent my attempts at creating a cummulative count of Planned tasks (column 3 above).
The (desired) resulting table should look like the Excel generated version below...with the yellow columns being the desired, calculated columns.
Any help would be greatly appreciated.
Thanks in advance.
Solved! Go to Solution.
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])))
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:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |