Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. 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
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 55 | |
| 34 | |
| 32 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 75 | |
| 72 | |
| 38 | |
| 35 | |
| 25 |