Split data into hourly buckets based off Start/End datetime?

[chad_oge]

I am starting with a simple table that contains Start and End values:

Based off these values, I would like to generate a new table that is bucketed into hourly values.  My desired result would look like this:

Any help on generating a result like this is much appreciated! Thanks you.

[Anonymous · Accepted solution]

Hi @chad_oge 

You can get the time list first and then subtract in chronological order .

Refer the following link to return the hourly values

https://community.powerbi.com/t5/Community-Blog/Convert-the-start-time-and-end-time-into-multiple-ro...

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.