Forum Discussion

Ethanhunt123's avatar
Ethanhunt123
Helper IV
1 year 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 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]
        )
    )
 

 

@Dax
@Daxhelp
@WeekName
  • BeaBF's avatar
    BeaBF
    1 year 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

1 Reply

  • BeaBF's avatar
    BeaBF
    Super User
    1 year 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