- I have created powerbi dashboard using azure devops analytics as data source
I have the list of fields from ado into powerbi
WorkItem ID
WorkItem Type
State
Parent Work ItemId
The items are epics, features, story, task which are related by parent work item id
I am looking for pulling out a rollup status and percentage completion at epic and feature level
I have tried to use the blank query in powerbi using the code in below link
I am able to save the query without any syntax error, however the query is not yielding any data. I am not sure how to overcome and get the data source that I can proceed with calculation of percentage
In the meantime is there a simple way to derive this percentage of features or epics rolled up based on their child status using the DAX or query
