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])))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
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])))