cancel
Showing results for
Did you mean:
Highlighted
Helper III

## 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.

---------------------------------------

Not the Power BI thought police...

##### I have NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

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.

---------------------------------------

Not the Power BI thought police...

##### I have NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Datanaut!

Helper III

## 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!

---------------------------------------

Not the Power BI thought police...

##### I have NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Datanaut!

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors