I am trying to pull in the last date that a resource has had a ‘capacity’ entry. I am able to get as far as the below, however the only date that I can figure out how to pull in is the maximum date that ANY capacity was entered, not the capacity date specific to the resource in the gallery.
This gallery is a list of ‘active’ resources that report to the current user.
Filter(
'CAPACITY RESOURCES',
'Resource Manager Name'.'Full Name' = User().FullName && Text(Status) = "Active"
),
The ‘Last Capacity Entry’ column
LookUp(
'CAPACITY DETAIL TRACKERS',
ThisItem.'Resource Name - Outlook' = 'Capacity Resource LookUp'.'Resource Name - Outlook',
First(Sort('CAPACITY DETAIL TRACKERS',DateValue('Capacity Date LookUp'.'Capacity Week Date'),Descending)).'Capacity Date LookUp'.'Capacity Week Date'
)
I am expecting to see the value 10/24/22 for Daniel and 10/10/22 for Allison
