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

5 years ago

Emanuel Hmm, maybe something like:

Measure =
  VAR __AddDays = 
    SWITCH(MAX('Table'[Priority]),
      "P1",5,
      "P2",10,
      20
    )
  VAR __CreatedDate = MAX('Table'[created date])
  VAR __Calendar1 = CALENDAR(MAX(__CreatedDate+1,__CreatedDate+30)
  VAR __Calendar2 = ADDCOLUMNS(__Calendar1,"WeekDay",WEEKDAY([Date],2))
  VAR __Calendar3 = FILTER(__Calendar2,[WeekDay]<6),[Date])
  VAR __Set = TOPN(__AddDays,__Calendar3,[Date],1)
RETURN
  MAXX(__Set,[Date])

Anonymous

Not applicable

4 years ago

Hi Greg_Deckler , opening this thread. I have this same scenario, however, I need to exclude weekends. May I ask for your inputs/help on this? Thank you.