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

Anonymous

Not applicable

6 years ago

Greg_Deckler I tried using your formula early on, but it would not allow me since I have some Ship Dates that start before Due Date. The error message said the formula could not allow for that.

Greg_Deckler

Community Champion

6 years ago

Oh, that would be the CALENDAR function. You would just have to create an IF statement to check which date is larger or smaller and then create your CALENDAR appropriately. Like this:

NetWorkDays = 
VAR __CreatedDate = MAX(NetWorkDays[created date])
VAR __ReviewDate= MAX(NetworkDays[review date])
VAR Calendar1 = 
  IF(
    __CreatedDate < __ReviewDate,
    CALENDAR(__CreatedDate,__ReviewDate),
    CALENDAR(__ReviewDate,__CreatedDate),
  )
VAR Calendar2 = ADDCOLUMNS(Calendar1,"WeekDay",WEEKDAY([Date],2))
RETURN COUNTX(FILTER(Calendar2,[WeekDay]<6),[Date])