Forum Discussion

SureshA's avatar
SureshA
Icon for Helper II rankHelper II
1 year ago
Solved

Velocity chart similar to Azure Devops

I am trying to build a velocity chart similar to Azure Devops to depict for each sprint 1. Planned 2. Completed  3. Removed   I have used ado analytic views with history  I am unable to get the...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.
     

     

HarishKM's avatar
HarishKM
Icon for Super User rankSuper User
1 year ago

SureshA Hey,
Try below steps as per my understanding -  

Use the current or final state at sprint end.

Completed = sum of story points for items in Done/Completed state at sprint end.

Removed = sum of story points for items moved to Removed/Removed state by sprint end.

 

 

PlannedPoints =
CALCULATE(
SUM(SnapshotTable[StoryPoints]),
SnapshotTable[Iteration] = SelectedSprint,
SnapshotTable[SnapshotDate] = SprintStartDate
)

 

Thanks

Harish KM

Please accept this as a solution if this solves your problem and give kudos as well.