This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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 May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 29 | |
| 27 | |
| 25 | |
| 20 | |
| 14 |
| User | Count |
|---|---|
| 53 | |
| 47 | |
| 22 | |
| 19 | |
| 19 |