cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tasB Frequent Visitor
Frequent Visitor

Aggregating Earliest Time Correctly

I'm working on a dataset where for a single user the data would look like below:

 

User, Activity, Time

User 1, SignOn, 7:50am

User 1, EnRouted, 8:00am

User 1, Arrived, 8:30am

User 1, Completed, 9:00am

.

.

.

User 1, SignOff, 4:00pm

 

And I can create a table showing this - filtering down to every user and find their earliest 'Arrived' status for a given day by using a filter on Arrived and giving me the earliest Time.

 

I want to take this a step further and look at multiple days/multiple users and find what the average earliest 'Arrived' status is.

 

For example:

 

User 1, Arrived, 8:00am

User 2, Arrived, 9:00am

User 3, Arrived, 9:30am

 

My average 'Arrived' time for the three employees should be 8:50am. 

 

Any help is much appreciated.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)