cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

## 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
Super User

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.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
3 REPLIES 3
Super User

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.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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

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

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

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

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors