Calculate Weekdays between dates

Ethanhunt123 — Fri, 06 Sep 2024 07:58:16 GMT

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]

)

Re: Calculate Weekdays between dates

BeaBF — Fri, 06 Sep 2024 08:17:10 GMT

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

topic Calculate Weekdays between dates in DAX Commands and Tips

Calculate Weekdays between dates

Re: Calculate Weekdays between dates