Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all.
I have a table which tells me some information related to the ParentWorkItemId, such as the Current Estimation of hours:
How can I have the sum of hours, when the ParentWorkItemId (red bellow) or the WorkItemId (black bellow) is equal to the ParentWorkItemId number on the previous table?
The Devops table is as follows:
Thank you in advance!
Solved! Go to Solution.
HI @Anonymous,
It seems like you are working with parent child hierarchy relationship requirement.
If you want to summary records according to this type of relationships, you can take a look at the following link to get the relationship path. Then you can write formula to extract the result path string to get correspond id list and use them as conditions to filter and aggregate records.
Parent-child hierarchies – DAX Patterns
Regards,
Xiaoxin Sheng
HI @Anonymous,
It seems like you are working with parent child hierarchy relationship requirement.
If you want to summary records according to this type of relationships, you can take a look at the following link to get the relationship path. Then you can write formula to extract the result path string to get correspond id list and use them as conditions to filter and aggregate records.
Parent-child hierarchies – DAX Patterns
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |