Forum Discussion
Azure Devops Epics % of Completion
Hello,
I am trying to find a way to extract the % of completion of epics in Azure Devops so I can use it in Power BI. I am familiar with the Progress of work items in the rollup column from the Backlog but I cannot seem to find a way to extract it. Thank you in advance for any help.
1 Reply
ferryvResolver II
Azure DevOps does not physically store that info, but you could use e.g. DAX in PowerBI For instance, if you base your completion percentage in an Epic based on item count, you can use DAX to go you a count of:
- All items in the Epic
- items completed in the Epic (based on state Done)
I did something similar in this article: https://www.linkedin.com/pulse/burnup-charts-powerbi-ferry-van-der-vorst/?trackingId=pXUX5lPbSpucooxyz2aTtw%3D%3D and https://www.linkedin.com/pulse/burndown-charts-powerbi-ferry-van-der-vorst/?trackingId=pXUX5lPbSpucooxyz2aTtw%3D%3D that might help you on your way. You might need to append the measure slightly to also filter on Epic as the examples base it on all info in a project, not by Epic.