Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hello,
i'm trying to read the hours that i've report on Azure, regarding Catalog Request that could have several User Stories, that could have several Tasks, like the example below:
CR CR Name US US Name Task Task Name
| 15843 | Catalog Request 1 | 15858 | User Story 1 | 28639 | Task 1 |
| 15843 | Catalog Request 1 | 15858 | User Story 1 | 28641 | Task 2 |
| 15843 | Catalog Request 1 | 15858 | User Story 1 | 28643 | Task 3 |
| 15843 | Catalog Request 1 | 15858 | User Story 1 | 28644 | Task 4 |
| 15843 | Catalog Request 1 | 15860 | User Story 2 | 47545 | Task 5 |
| 15843 | Catalog Request 1 | 15860 | User Story 2 | 47545 | Task 5 |
| 15843 | Catalog Request 1 | 15860 | User Story 2 | 47545 | Task 5 |
| 15843 | Catalog Request 1 | 15860 | User Story 2 | 50130 | Task 6 |
| 15843 | Catalog Request 1 | 15860 | User Story 2 | 50130 | Task 6 |
| 15843 | Catalog Request 1 | 15860 | User Story 2 | 50130 | Task 6 |
| 15843 | Catalog Request 1 | 15860 | User Story 2 | 50130 | Task 6 |
i'm trying to sum the hours from the timeline, but it repeats on the CR the hours from the US and from the Tasks. How can i do a sum correctly ?
thanks,
JR
Hello CRT,
sorry for the reponse delay.
i give other example, that i think its more clear.
How can i maker that calculation ? just a correction its not total hours of process son (the correct is the main process, but the IDs are correct)
Thanks for the help,
JR
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 49 | |
| 40 | |
| 32 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 87 | |
| 72 | |
| 37 | |
| 28 | |
| 26 |