In PowerPivot I'm trying find the Min value in a table based on two column values. My data contains multiple people, on multiple dates with multiple segments of time. For each person on each date I need to determine the earliest segment of time in the data.
I was able to use this in data on a daily basis and it works fine but when I add multiple days to the data it only locates the minimum segment of time for each person, not each person for each date listed.
=
IF (
CALCULATE (
MIN ( [start] ),
FILTER ( actual, [Agent_User_Name] = EARLIER ( [Agent_User_Name] ) )
)
= [start],
TRUE (),
FALSE ()
)
Agent_User_Name date start
Susan 1/1/19 08:00
Susan 1/1/19 08:45
Susan 1/1/19 10:00
Susan 1/2/19 08:30
Susan 1/2/19 09:00
Timothy ....
I am trying to determine that Susan's earliest time on 1/1/19 was 08:00, on 1/2/19 was 08:30 and mark that record as true or false for earliest time.