Calculate Weekdays between dates

[Ethanhunt123]

I have created a DAX formula to calculate weekdays, excluding Sundays, Saturdays, and holidays. It is working fine for all the rows. However, I'm not sure why, but it is causing an issue for one specific record.

CALCULATE (

        COUNTROWS ( 'Order create date' ),

        FILTER (

            'Order create date',

            WEEKDAY ( 'Order create date'[Order create date], 2 ) < 6  && 'Order create date'[Is holiday] =0

        ),

        DATESBETWEEN (

            'Order create date'[Order create date],

            'Sales order line'[Created date (weekday)] + 1,

            'Sales order line'[Ship date requested]

        )

    )

[BeaBF · Accepted solution]

@Ethanhunt123 Hi! Try with:

CALCULATE (
COUNTROWS (
FILTER (
'Order create date',
WEEKDAY ( 'Order create date'[Order create date], 2 ) < 6 -- Exclude Saturdays (6) and Sundays (7)
&& 'Order create date'[Is holiday] = 0 -- Exclude holidays
&& 'Order create date'[Order create date] >= 'Sales order line'[Created date (weekday)] + 1
&& 'Order create date'[Order create date] <= 'Sales order line'[Ship date requested]
)
)
)

BBF