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 ins...
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