Forum Discussion

Ethanhunt123's avatar
Ethanhunt123
Icon for Helper IV rankHelper IV
2 years ago
Solved

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 spec...
@Dax
@Daxhelp
@WeekName
  • BeaBF's avatar
    BeaBF
    2 years ago

    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

BeaBF's avatar
BeaBF
Icon for Super User rankSuper User
2 years ago

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