Net Work Days

Recreates the NETWORKDAYS function from Excel with some bonus measures and one that needs fixed or demonstrates a bug/documentation glitch. NetWorkDays calculates the number of days between two...

NetWorkDays.pbix80 KB

Other

Time Intelligence

Greg_Deckler

Community Champion

7 years ago

Anonymous - Sure, you could do something like this:

NetWorkDays = 
VAR Calendar1 = CALENDAR(TODAY(),[Any Given Date])
VAR Calendar2 = ADDCOLUMNS(Calendar1,"WeekDay",WEEKDAY([Date],2))
RETURN COUNTX(FILTER(Calendar2,[WeekDay]<6),[Date])

If necessary, reverse the parameters for the CALENDAR function.

Anonymous

Not applicable

7 years ago

Thanks Greg_Deckler this works like a charm.