How to find holidays between two dates? What DAX should be used instead of NETWORKDAYS ?

[Maru]

Unlike Excel, Dax NETWORKDAYS requires weekend parameter. 

This is my workaround but it always takes 10 seconds when I touch this calculated columns although the elements in 'holidays lists' table is about the same.

VAR holidays_count = COUNTROWS(FILTER('holidays lists', 'holidays lists'[date] >= table[start Date] && 'holidays lists'[date]    <= end Date))

 
Any better way to do it ? Thank you in advance.

[Anonymous · Accepted solution]

Hi @Maru ,

You can try formula like below:

HolidaysCount =
IF (
    CALCULATE (
        COUNTROWS ( 'holidays lists' ),
        FILTER (
            'holidays lists',
            'holidays lists'[date] >= MAX ( YourTable[Start Date] )
                && 'holidays lists'[date] <= MAX ( YourTable[End Date] )
        )
    ) > 0,
    "holiday",
    "no holiday"
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[saurabhtd]

@Maru  You can try this logic. 

holidays_count =
    CALCULATE(
        COUNTROWS('holidays lists'),
        TREATAS(
            VALUES('holidays lists'[date]),
            'table'[start Date],
            'table'[end Date]
        )
    )