Need urgent help in burndown chart for Feature completion in Sprint PI

[Abhi15]

Hello Community,
  

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.

I am expected to get the outcome as in above snap

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

Thanks in advance
@PBICommunity  @Greg_Deckler  @Anonymous @Anonymous @v-weiyan1-msft 

[Abhi15]

@Greg_Deckler , Thank you so much for this DAX cookbook. But the code is related to remaining hours. And here I have to show feature completion counts. Could you please give any idea on how can I achieve it.

[Greg_Deckler]

@Abhi15 I did a burndown chart in DAX Cookbook. Can't remember the chapter or recipe and not in my home office or I could check. The PBIX files are available here: PacktPublishing/DAX-Cookbook: DAX Cookbook, Published by Packt (github.com)