• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Rolling Hour / Peak Hour Power BI|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / Rolling Hour / Peak Hour Power BI|General Excel Questions & Answers|Excel Forum|My Online Training Hub

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope




Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_CrumbsHome HomeExcel ForumGeneral Excel Questions & Answe…Rolling Hour / Peak Hour Power BI
sp_PrintTopic sp_TopicIcon
Rolling Hour / Peak Hour Power BI
Avatar
Max Neumann

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
April 21, 2018
sp_UserOfflineSmall Offline
1
April 21, 2018 - 12:16 am
sp_Permalink sp_Print

Hello,
i saw your really helpful videos on YouTube and wanted to ask for your help in excel issue. 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 five minutes time window. That means the numbers of flights from e.g. 1pm to 2pm or 1:25pm to 2:25 or 1:40 to 2:40 and so far. All those “rolling hours” needs to be plotted in a day chart so I can 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. I would be vary thankful if you try to help me and show me the right way to do that in excel or Power Bi.
Thank you so much for your time hope to hear from you
with best regards
Sven

sp_AnswersTopicSeeAnswer See Answer
Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4515
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
2
April 24, 2018 - 10:13 am
sp_Permalink sp_Print

Hi Max,

Please find the attached file that summarises the data in a PivotTable (chart sheet), then uses SUMIFS to aggregate the data into a rolling 5 minute hour (Chart Data table in columns D:F). The Slicers allow you to control what values the PivotTable returns, which in turn filters the Chart Data and chart.

Not sure you can do this (efficiently) with Power BI/Power Pivot because they don't have time intelligence functions for times (only available for dates).

Mynda

sp_AnswersTopicAnswer
Answers Post
Avatar
Max Neumann

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
April 21, 2018
sp_UserOfflineSmall Offline
3
April 24, 2018 - 10:26 pm
sp_Permalink sp_Print

Hi Mynda, thank you so much. thats exactly what i need to get. 🙂

Avatar
Max Neumann

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
April 21, 2018
sp_UserOfflineSmall Offline
4
April 25, 2018 - 12:25 am
sp_Permalink sp_Print

Hi Mynda,

after analysing the data i found some wrong sums. I hightlighted the area in the attache file. The SUMIFS in H14 should shows 1.283 Pax (sum from passengers from 00:55:00 - 01:50:00) but it shows only 1.095 ? The most sumifs are correct but some are wrong. What is the matter for that and can you help?

 

Thanks a lot again.

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4515
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
5
April 25, 2018 - 8:56 am
sp_Permalink sp_Print

Hi Max,

That file you attached (rolling-hour_peak-hour-2.xlsx) doesn't have any formulas in it.

Mynda

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Babak Damadi, Jessica Stewart, Sherry Fox, Franziska Reinbold, Moussa Dicko, Alberto Garavaglia, Suleika R Torres, Barry Tobin
Guest(s) 10
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 216
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
leandro barbarini
Melanie Ford
Isaac Felbah
Adele Glover
Hitesh Asrani
Rohan Abraham
Anthony van Riessen
Erlinda Eloriaga
Abisola Ogundele
MARTYN STERRY
Forum Stats:
Groups: 3
Forums: 24
Topics: 6356
Posts: 27793

 

Member Stats:
Guest Posters: 49
Members: 32325
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —sp_Information

Sidebar

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk - For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.