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

BachFel

Helper II

8 years ago

Thanks for your help,

NetWorkDays =
VAR Calendar1 = CALENDAR(MAX(KontElemente[Datum der Besichtigung]);MAX(today())

I didn´d understand the part.

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

Can u help me out?

Greg_Deckler

Community Champion

8 years ago

If you are referring to the VAR Calendar2 part, what that does is adds a column to the temp calendar table using the WEEKDAY function with the parameter 2, which essentially codes things M=1, T=2, W=3, Th=4, F=5, Sa=6, Su=7. So, the next step, the RETRUN filters out anything 6 or 7 to exclude Saturdays and Sundays.

BachFel
Helper II
8 years ago
It´s not working. Guess I´m the problem and not the formula
- Greg_Deckler
  Community Champion
  8 years ago
  You are missing a ) at the end of your line beginning with VAR Calendar1
  - Emanuel
    Helper I
    6 years ago
    
    Hi Greg_Deckler, I used the function dor the networkdays but I get this error. Is it possible to have this but instead of a closed date column to use the NOW/TODAY date?
    
    Thanks for the help.