DAX - Sum Workdays By Month within Range

1
votes

I've been at this one a while.

Objective: Pivot a monthly summary of days worked by Resource within the range for that Resource line where those dates (from StartDate to EndDate) correspond to the Dates table IsWorkday field.

enter image description here

Thanks for your help!

1
business-intelligencepowerpivotdax

1 Answers

0
votes

It depends on how you define what a workday is. I suspect this is Monday thru Friday? If so, try the weekday function.

=WEEKDAY(serial_number,2)

Where serial_number is the cell with a date you want to identify. This would not exclude holidays, I would recommend an index/match on some holiday reference table for that.

https://support.office.com/en-us/article/WEEKDAY-function-60e44483-2ed1-439f-8bd0-e404c190949a