cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
acteno
New Member

Define returning time slots for time rows to perform specific/comparative calculations

Dear community,

 

while working on a project, based on databases containing continuous time rows, we have the following cases that we cannot solve:

 

Given for both cases: a continuous time row with time stamp and data values for every 15 minutes; the data source is a database that refreshes automatically

 

Time slots per day:

Required: define a specific time slot or several ones for different days and then only perform calculations on the according data or compare it to the data lying out of this frame

Example1: number of customers in a bistro; then only take a closer look on peak hours during lunch time (12.00am-2.00pm)

Example2: phone calls to a hotline; phone calls to that hotline in the evening (5.00-9.00pm)

 

Time slots changing with seasonality and over-seasonal comparison:

Required: define a time slot that changes with the seasons (4x per year), perform calculations on the data outside and inside this time frame according to the season, but also using data which lies out of the season but in the same year

Case: compare maximum value of the season, that is not in the defined time frame and compare it to maximum value of the whole year

 

Thanks for your help.

1 REPLY 1
Greg_Deckler
Super User
Super User

Really difficult to answer this without sample data.

 

For the first one, you can do this a bunch of different ways. You could create a measure based upon COUNT and either create a slicer based on hour or you could create a new column and use an IF statement to create your "categories" essentially.

 

For the second one, again, this sounds like a measure or maybe two measures but not nearly enough info to go on.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.