The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
@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.
@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)
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
24 | |
14 | |
13 | |
9 | |
7 |