Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am new to Power BI and I am having trouble creating a report based on data extracted from Azure DevOps. This is the way data is structured:
[1]: /answers/storage/temp/250218-table.jpg
I need to get totals by:
- User Story
- Bug
- All User stories per feature
- All bugs per feature
- Feature (all its user stories & bugs per feature combined)
- Epic (all its features combined)
- Everything (all epics)
I tried using Power Query Editor / Group By (ribbon button) but Parent ID is not listed. Another option I thought were developing a program in Python to calculate these subtotals and update the table, but it will be more work each time the data is updated.
How can I get the values I need?
Many thanks in advance.
Solved! Go to Solution.
Thank you, Ashish. Unfortunately I could not find the answer in your websites. What I did was to link the same data source 4 times and rename them as Task, Story, Feature and Epic. Then, I linked those tables using work item id -> parent work item id. That created an inner join that now lets me summarize the tasks at any level (stories, features and epics). Hopefully this works for other folks.
Hi,
Show the exact result that you are expecting.
Thank you, Ashish. Unfortunately I could not find the answer in your websites. What I did was to link the same data source 4 times and rename them as Task, Story, Feature and Epic. Then, I linked those tables using work item id -> parent work item id. That created an inner join that now lets me summarize the tasks at any level (stories, features and epics). Hopefully this works for other folks.