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

can you use the NETWORKDAYS function ?

 

Working Days Test =

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

return

NETWORKDAYS(_EndDate,_StartDate,1)
  • jimbob2285's avatar
    jimbob2285
    Icon for Advocate IV rankAdvocate IV
    3 years ago

    Hi

     

    Hi Ikhall

     

    Thanks, Yes, NETWORKDAYS certainly overcomes the problem of negative days, calculating them correctly, but is there a way to reference a holiday table do you know?  It will be a bit long winded to add each holiday for a single year, with bank holidays and Christams shut down, let alone all those holidays for a number of years

     

    Cheers

    Jim

    • 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