Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!