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