Forum Discussion

cottrera's avatar
cottrera
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

DAX working days current month

Hi    I need a DAX function to work out the working days for the current month.  For example February 2021 = 20 working days. Next month March 2021 = 23 working days and April 2022 =20   In addi...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    cottrera , try measures like

     

    Working days passed = CALCULATE(SUM('Date'[is Working day]),DATESMTD('Date'[Date]))

    this month = CALCULATE(SUM('Date'[is Working day]),DATESMTD(ENDOFMONTH('Date'[Date])))

cottrera's avatar
cottrera
Icon for Post Prodigy rankPost Prodigy
4 years ago

Hi Amitchandak

 

thank you for your quick response. I have tried both measure , however they both give the same result

 

 

regards

 

Richard

 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    cottrera , Try like

     

    MTD=
    var _min = eomonth(today(),-1)+1
    var _max = today()
    return
    CALCULATE(SUM('Date'[is Working day]), FILTER(ALL('Date'),'Date'[Date] >= _min && 'Date'[Date] <=_max ) )

     

     

    or

     

    Working days passed = CALCULATE(SUM('Date'[is Working day]),DATESMTD('Date'[Date]), 'Date'[Date] <=today() )