Forum Discussion
Solved
NETWORKDAYS dynamically filtering by dates and person
I want to calculate the working days between dates with varying holidays within a specified period. For example, I have a table that lists personal holidays: Person Holidays Jane 02-Feb-2...
Albatross810 So like this?
Measure = VAR __Person = MAX('Jobs'[Person]) VAR __Result = NETWORKDAYS(MAX([Start]), MAX([End]), 1, SELECTCOLUMNS(FILTER('Holidays', [Person] = __Person),"__Holidays",[Holidays])) RETURN __Result
Albatross810 So like this?
Measure =
VAR __Person = MAX('Jobs'[Person])
VAR __Result = NETWORKDAYS(MAX([Start]), MAX([End]), 1, SELECTCOLUMNS(FILTER('Holidays', [Person] = __Person),"__Holidays",[Holidays]))
RETURN
__Result
Thanks so much, this worked well!