FIltering a list
I have a problem regarding filtering.
I have two tables, one which basically list all the “days” of the year like: 2/28/2018 3/1/2018 3/2/2018
The other table list volunteers availability. I have a different column for each day. For example
Tuestay John Doe
yes Jane Doe
I manage to filter Mondays with this formula:
SELECT(LocalVolunteers[ComputedName],AND([TRC]=LocalVolunteers[TRC], WEEKDAY([WEEK])=2, ISNOTBLANK(LocalVolunteers[Available on Monday?]))) However it’s a challenge to list the volunteers for Tuesdays, ect.