Forum Discussion
Helper IIVelocity chart similar to Azure Devops
Hi SureshA ,
we get that you cant share the official data but it is working as expected with our sample data. could you please explain more on mismatch so we can try changing Dax,find the attached file for your reference.
Regards,
Harshitha.
Helper IIThanks
I have the following fields with all history from ado analytics view filtered for my required squads
1. Work item type
2. Iteration path
3. Interation start date
4.. Iteration end date
5. Created date
6. Changed Date
7. Story points
In your dax measure for planned story points, you have referred
<<WorkItemBoardSnapshot table from your Analytics View and a related 'Sprints' table with start dates>>
- I have only one table which has history along with the above listed fields containing sprint start date i.e iteration start datehow do I use this in the Dax
- secondly ado also considers story points that got planned during sprint progress. How do I sum up these with the created and change date
Hi SureshA,
Thank you for your followup.
It shows how to load your data, create DAX measures using your existing columns like Iteration Start Date, Changed Date, Created Date, and State, and finally build a stacked column chart.
I tested it with my sample data, and it worked fine. Please find the attached screenshot and Pbix for your reference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it
Best Regards,
Harshitha.
- SureshA
Thanks for your revert. Pls can you provide the dax I can't download the pbix in my official env
Hi SureshA,
Thank you for getting back to me.
I will share the DAX formula directly here so you can implement it in your report:Added During Sprint = VAR SprintStart = MIN('Planned Story Points'[Iteration Start Date]) VAR SprintEnd = MIN('Planned Story Points'[Iteration End Date]) VAR SprintPath = SELECTEDVALUE('Planned Story Points'[Iteration Path]) RETURN CALCULATE( SUM('Planned Story Points'[Story Points]), FILTER( 'Planned Story Points', 'Planned Story Points'[Iteration Path] = SprintPath && 'Planned Story Points'[Changed Date] > SprintStart && 'Planned Story Points'[Changed Date] <= SprintEnd ) )Completed Story Points = VAR SprintPath = SELECTEDVALUE('Planned Story Points'[Iteration Path]) RETURN CALCULATE( SUM('Planned Story Points'[Story Points]), FILTER( 'Planned Story Points', 'Planned Story Points'[Iteration Path] = SprintPath && 'Planned Story Points'[State] IN { "Done", "Closed" } ) )Planned Story Points = VAR SprintStart = MIN('Planned Story Points'[Iteration Start Date]) VAR SprintPath = SELECTEDVALUE('Planned Story Points'[Iteration Path]) RETURN CALCULATE( SUM('Planned Story Points'[Story Points]), FILTER( 'Planned Story Points', 'Planned Story Points'[Iteration Path] = SprintPath && 'Planned Story Points'[Changed Date] <= SprintStart ) )
If you face any challenges applying this, feel free to share more details, and I will be happy to guide you step by step.
Best regards,
Harshitha.
Microsoft Fabric Community Support.- SureshA
Hi Anonymous thanks for sharing dax formulas. I have used in my data set to depict then them in stack column chart.
- I am able to get more story points, since the computation is done on all rows. I have used history in my ado analytics view hence my dataset has multiple rows for each work item. I need to get the latest update done on the work item to compute planned story points