Forum Discussion

jimbob2285's avatar
jimbob2285
Icon for Advocate IV rankAdvocate IV
3 years ago
Solved

DAX Count working days between two dates

Hi   I've come across this DAX code to count the working days between two dates, that uses my date table to define if a day is a working day or not   Days Overdue = CALCULATE(         COUNTRO...
  • Anonymous's avatar
    Anonymous
    3 years ago

    can you use the NETWORKDAYS function ?

     

    Working Days Test =

    var _StartDate= 2023-07-28
    var _EndDate = 2023-07-25

    return

    NETWORKDAYS(_EndDate,_StartDate,1)
Anonymous's avatar
Anonymous
Not applicable
3 years ago

what are you using for a date dimension table currently ? 

jimbob2285's avatar
jimbob2285
Icon for Advocate IV rankAdvocate IV
3 years ago

I've built my own date table in SQL