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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Sven01
Helper I
Helper I

rolling hour / peak hour

 

 

The data basis that i need to analyse is an historical flight plan of an airport. That means I have a flight plan with each flight of the day and the arrival time. What i wanted to know is the rolling peak hour of arrivals in 5 min phases. That means the numbers of flights from e.g. 1pm to 2pm or 1:05pm to 2:05 or 1:10 to 2:10 and so far. All those "rolling hours" needs to be plotted in a day chart from 00:00 to 11:55 to find the "max. peak hour" of the day. It would be also great to filter the flight of the day by e.g. airline or departure destination and get also the rolling peak hour and max. peak hour of the day.

 

Thank you so much for your time hope to hear from you

 

attached data file:

 Flightplan

1 ACCEPTED SOLUTION

Hi @Sven01,

 

Please check the sample report. See if it works for you"

 

https://1drv.ms/u/s!AlqSnZZUVHmshgLUM42dhAb59BwT

 

Thanks,
Xi Jin.

View solution in original post

13 REPLIES 13

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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