Forum Discussion

Frequent Visitor

5 years ago

Solved

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

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

Need Help

Anonymous
5 years ago
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-rows-with-30/ba-p/1478630

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.

Anonymous

Not applicable

5 years ago

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-rows-with-30/ba-p/1478630

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.

Forum Discussion

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

Related content

Error in Power Query combining overlapping start end datetime fields

EBIT Financial Bridge - Dynamic Start and End

Create DateTime List between start datetime & end DateTime

Between date filter with fixed start date and latest end date

Start and end selection with datetime