Forum Discussion

Shankar's avatar
Shankar
Regular Visitor
9 years ago
Solved

equivalent function of Networkdays in DAX

Hi Team - I need to calculate the total number of business days between two dates. Attached the file and the results. Please help.
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Shankar,

     

    You can try to use below calculate column formula to calculate the total normal workday.(except saturday sunday)

    Total WorkDays =
COUNTROWS (
    FILTER (
        ADDCOLUMNS ( CALENDAR ( [Start], [End] ), "Day of Week", WEEKDAY ( [Date], 1 ) ),
        [Day of Week] <> 1
            && [Day of Week] <> 7
    )
)

     

    If you need to remove other holidays, you need to create a holiday table and remove them in the formula.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Shankar,

 

You can try to use below calculate column formula to calculate the total normal workday.(except saturday sunday)

Total WorkDays =
COUNTROWS (
    FILTER (
        ADDCOLUMNS ( CALENDAR ( [Start], [End] ), "Day of Week", WEEKDAY ( [Date], 1 ) ),
        [Day of Week] <> 1
            && [Day of Week] <> 7
    )
)

 

If you need to remove other holidays, you need to create a holiday table and remove them in the formula.

 

Regards,

Xiaoxin Sheng

  • Shankar's avatar
    Shankar
    Regular Visitor
    9 years ago

    Thanks a lot Sir. It works :manhappy: . 

     

    Was looking for it badly.

     

     

    Thanks,

    Shankar A

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I write Same Dax Function but it is showing The start date or end date in Calendar function can not be Blank value.
    is ther any function to remove that error.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    "If you need to remove other holidays, you need to create a holiday table and remove them in the formula."

    Maybe you can show me?