Forum Discussion

WLFRD's avatar
WLFRD
Helper III
4 years ago
Solved

WorkingDays - Excluded weekends

Hello,   I would like to get some help with the nex issue. I have a table with to dates. A simple Datediff wil calculate the day diffencence between the two given dates in the table.   D_ENTER...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI WLFRD,

    You can use countrows and weekday functions to create a calculated column to achieve your requrement:

    Datediff =
COUNTROWS (
    FILTER (
        CALENDAR ( Table[D_ENTER_DATE], Table[D_PROM_ENTER_DATE] ),
        WEEKDAY ( [Date], 2 ) < 6
    )
)

    Regards,

    Xiaoxin Sheng