topic Re: Burndown Chart for Sprint Planning in DAX Commands and Tips

Burndown Chart for Sprint Planning

Anonymous — Wed, 13 Dec 2023 11:07:42 GMT

Hello Community,

I have to create a Burdown graph using Line chart for PI Planning. Our 1 PI is equal to 1 Quarter i.e. 3 months.

Now, I have to show Planned vs Actual completion of Features in Current PI using Line Chart.

Would really appreciate if anyone please help with DAX on how we can achieve that. Below is the data for your reference,

Feature_ID PI PI_Start_Date PI_End_Date Feature_Start_date Feature_End_date Feature_Plan_End_Date
111 Q1.24 01-15-2023 04-15-2023 01-17-2023 02-10-2023 02-15-2023
123 Q1.24 01-15-2023 04-15-2023 02-13-2023 03-13-2023 03-29-2023
14566 Q1.24 01-15-2023 04-15-2023 03-15-2023 04-10-2023 04-15-2023

Thanks in advance

Re: Burndown Chart for Sprint Planning

lbendlin — Sun, 17 Dec 2023 00:56:36 GMT

What would be the expected outcome based on your sample data?

Re: Burndown Chart for Sprint Planning

Anonymous — Sun, 17 Dec 2023 15:59:12 GMT

Thank you so much for your reply lbendlin , above is the outcome I am expecting. So here I am Showing Projected Completion rate Vs Planned Target Date. Let me make it more simple with below sample data

Feature_ID PI Start_Date Projected_End_Date Target_Date
111 Q1.24 01-15-2024 03-07-2024 04-15-2024
123 Q1.24 01-15-2024 03-21-2024 04-21-2024
14566 Q1.24 01-15-2024 03-28-2024 04-29-2024

Here, for "Projected Completion Rate" we have Start_Date and End_Date. For "Planned Target Rate" we have Target Date. Now, with all this data I have to generate Burndown chart just like above for current quarter (It should take the current quarter automatically). So basically, we have to see feature completed with respect to Planned Target Rate. For example, on 9th Sep there were 5 features and then on 18 October there are 4 features.

Could you pleaes help me with this on how we can implement this? Please let me know if more data or more info is needed.

Thanks for your time.

Re: Burndown Chart for Sprint Planning

lbendlin — Sun, 17 Dec 2023 15:08:35 GMT

please check your sample data. Are you mixing up 2023 and 2024?

Re: Burndown Chart for Sprint Planning

Anonymous — Sun, 17 Dec 2023 15:58:44 GMT

lbendlin We can consider below data, apologies, we are moving to next quarter hence I took 2024 dates. Please consider below data for above expected output. Apologies for the confusion. Dates are now corrected

Feature_ID PI Start_Date Projected_End_Date Target_Date
111 Q1.24 01-15-2024 03-07-2024 04-15-2024
123 Q1.24 01-15-2024 03-21-2024 04-21-2024
14566 Q1.24 01-15-2024 03-28-2024 04-29-2024