Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
pamlorensampaio
Frequent Visitor

Power Query CALENDAR request - From a date table how can I include times intervals of an hour?

Hi All, 

 

I have a calendar table ready, but I am unable to generate series or create hours invervals related to the days. 

 

Eg. 

This is my table: 

 

pamlorensampaio_0-1696228756560.png

 

 

However I need to have the hour/time in an hour intervals for each day like:

pamlorensampaio_1-1696228755813.png

 

Can anyone help? 

 

 

 

 

 

1 ACCEPTED SOLUTION
AlienSx
Super User
Super User

hello, @pamlorensampaio 

let
    Source = your_table,
    dn = List.Buffer(List.Transform({0..23}, (x) => #duration(0, x, 0, 0))),
    date_hour = Table.AddColumn(Source, "Value", (x) => List.Transform(dn, (y) => x[Date and Time Start] + y)),
    expand = Table.ExpandListColumn(date_hour, "Value")
in
    expand

View solution in original post

2 REPLIES 2
AlienSx
Super User
Super User

hello, @pamlorensampaio 

let
    Source = your_table,
    dn = List.Buffer(List.Transform({0..23}, (x) => #duration(0, x, 0, 0))),
    date_hour = Table.AddColumn(Source, "Value", (x) => List.Transform(dn, (y) => x[Date and Time Start] + y)),
    expand = Table.ExpandListColumn(date_hour, "Value")
in
    expand

Thank you! It created another query and worked! 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.