Forum Discussion

mstefancik's avatar
mstefancik
Advocate IV
10 years ago
Solved

Networkdays DAX function

Hello, can somebody help me? Is there any simple method how to calculate Working Days left in actual month? In excel I am using NETWORKDAYS function.   Any example?   Thanks
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    Try something like this:

     

    WD = VAR WDinMonth = CALCULATE(COUNTROWS('Calendar');
FILTER('Calendar'; 'Calendar'[DayOfWeekNumber] >= 1
&& 'Calendar'[DayOfWeekNumber] <= 5 ))

VAR WDinMonthThusFar = CALCULATE(COUNTROWS('Calendar');
FILTER('Calendar'; 'Calendar'[DayOfWeekNumber] >= 1
&& 'Calendar'[DayOfWeekNumber] <= 5 ) && 'Calendar'[Date] < TODAY())

RETURN (WDinMonth -WDinMonthThusFar)

    I'm assuming you have some sort of [Date] column in your table.

mstefancik's avatar
mstefancik
Advocate IV
10 years ago

Already found it and now it works like a charm. Many thanks Greg_Deckler.

 

FYI error was in the second filter, mismatch of parenthesis.

WD = VAR WDinMonth = CALCULATE(COUNTROWS('Kalendar');
FILTER('Kalendar'; 'Kalendar'[DayOfWeekNumber] >= 1
&& 'Kalendar'[DayOfWeekNumber] <= 5 ))

 

VAR WDinMonthThusFar = CALCULATE(COUNTROWS('Kalendar');
FILTER('Kalendar'; 'Kalendar'[DayOfWeekNumber] >= 1
&& 'Kalendar'[DayOfWeekNumber] <= 5 && 'Kalendar'[Date] < TODAY()))

 

RETURN (WDinMonth -WDinMonthThusFar)

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Can we get this to exclude holidays?