cancel
Showing results for
Did you mean:
Member

## Averaging by Hour

Hi,

I have multiple stores where the staff schedule is for every 5 minutes. I need to work out the median staff quantity per hour for each store for each day for each staff type. 🙂

Is this possible? I have been hunting the solution for a couple of days.

 Store Date Time Hour Quantity Staff Type Peters 01-Feb-18 9:00 AM 9 4 Cashier Peters 01-Feb-18 9:05 AM 9 4 Cashier Peters 01-Feb-18 9:10 AM 9 4 Cashier Peters 01-Feb-18 9:15 AM 9 4 Cashier Peters 01-Feb-18 9:20 AM 9 4 Cashier Peters 01-Feb-18 9:25 AM 9 4 Cashier Peters 01-Feb-18 9:30 AM 9 4 Cashier Peters 01-Feb-18 9:35 AM 9 4 Cashier Peters 01-Feb-18 9:40 AM 9 4 Cashier Peters 01-Feb-18 9:45 AM 9 4 Cashier Peters 01-Feb-18 9:50 AM 9 4 Cashier Peters 01-Feb-18 9:55 AM 9 4 Cashier Peters 01-Feb-18 10:00 AM 10 6 Cashier Peters 01-Feb-18 10:05 AM 10 6 Cashier Peters 01-Feb-18 10:10 AM 10 6 Cashier Peters 01-Feb-18 10:15 AM 10 6 Cashier Peters 01-Feb-18 10:20 AM 10 6 Cashier Peters 01-Feb-18 10:25 AM 10 6 Cashier Peters 01-Feb-18 10:30 AM 10 6 Cashier Peters 01-Feb-18 10:35 AM 10 6 Cashier Peters 01-Feb-18 10:40 AM 10 6 Cashier Peters 01-Feb-18 10:45 AM 10 6 Cashier Peters 01-Feb-18 10:50 AM 10 6 Cashier Peters 01-Feb-18 10:55 AM 10 6 Cashier
1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV

## Re: Averaging by Hour

Just put Store and Hour in a table. Don't summarize Hour. Now put Quantity in the table and choose the "Median" aggregation. Like Page 1 of the attached file.

### I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

3 REPLIES 3
Super User IV

## Re: Averaging by Hour

Just put Store and Hour in a table. Don't summarize Hour. Now put Quantity in the table and choose the "Median" aggregation. Like Page 1 of the attached file.

### I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Member

## Re: Averaging by Hour

I dont know why I didnt realize this myself... When you too deap into it you dont take a chance to step back.

Super User IV

## Re: Averaging by Hour

That's why we're here, to be that other set of eyes!

### I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Announcements

#### Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

#### Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors