Forum Discussion
Events for a Period time
Hello I'm begings to use Power BI and I'm interesting to know if someone can help.
Problem:
How to measure the correct Duration by Hour?
If I sum the column"Hour" I get a wrong value of 143 instead of 104.18 as table below.
My doubt is I need to duplicate the rows breakdown the times or it's possible a metric to analize the data.
| Start | End | Duration (sec) | hour |
| 2022-09-09T07:58:15.753 | 2022-09-09T07:58:21.820 | 6 | 7 |
| 2022-09-09T07:58:21.820 | 2022-09-09T08:00:38.357 | 137 | 7 |
| 2022-09-09T08:00:38.357 | 2022-09-09T08:04:48.450 | 250 | 8 |
| Hour | SUM_Duration by hour | Sum_Duration by period |
| 7 | 143 | 104.18 |
| 8 | 250 | 288.82 |
1 Reply
Your request is much more complex than it may sound. For each event you need to find the intersect of your event interval with the Hour buckets. Events can also span multiple hours and even days.
- Please confirm that second level accuracy is enough. Specify the rounding rules
- Specify the expected bucket sizes (hours/days etc)
- Confirm that you want all this to be done in UTC
- provide sample data that covers all scenarios
