Calculate Weekdays between dates
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] ) )
