equivalent function of Networkdays in DAX

[Shankar]

Hi Team - I need to calculate the total number of business days between two dates. Attached the file and the results. Please help.

[bengisby]

Hello, could someone show me how to remove holidays as well?

[v-shex-msft]

Hi @bengisby,

If you have other specific holiday need to remove for current date range, you can try to use except function to compare with current visual calendar table. My formula will remove weekend dates from virtual calendar table.

Other reference link:

DATEDIFF Working Days

Regards,

Xiaoxin Sheng

[bengisby]

@v-shex-msft, this link is great, but I'm just learning and don't understand how to insert the measure result as a value in the new column... I have a business days value for each row of data, and so I need each row to also remove the holidays.

[v-shex-msft · Accepted solution]

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]

"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? 

[Anonymous]

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.

[Shankar]

Thanks a lot Sir. It works  . 

Was looking for it badly.

Thanks,

Shankar A