topic Re: Count open days of any month in DAX Commands and Tips

Count open days of any month

Anonymous — Thu, 18 Feb 2021 08:53:51 GMT

Hello,

I'm working on a dax to calculate the open days in a month. For example, I would like to calculate the open days of March month. So the dax that I wrote is :

OD = CALCULATE(DISTINCTCOUNT('Calendar'[Date]),FILTER('Calendar','Calendar'[Month]=MONTH(NOW())+1))

So the result is: 31 days, is the number of all days of March month.

Do you have any tips to calculate the open days of any month?

Thank you in advance.

Regards,

Re: Count open days of any month

amitchandak — Thu, 18 Feb 2021 09:02:17 GMT

Anonymous ,

Not very clear what is open days?

Total day in current month = day(eomonth(Today(),0)

Total day in next month = day(eomonth(Today(),1)

Re: Count open days of any month

Anonymous — Thu, 18 Feb 2021 09:13:12 GMT

amitchandak

Open days are the days that we work on: from Monday to Friday. For example, for March the open days are 23, not 31. I would like to calculate it for all months!

Regards,

Re: Count open days of any month

amitchandak — Thu, 18 Feb 2021 09:14:13 GMT

Anonymous , for next month

Work Day = COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR(EOMONTH(TODAY(),0)+1, EOMONTH(TODAY(),1)),"WorkDay", if(WEEKDAY([Date],2) <6,1,0)),[WorkDay] =1))

Re: Count open days of any month

Anonymous — Thu, 18 Feb 2021 15:55:49 GMT

Here's how to do that demonstrated by the Master of DAX, Alberto Ferarri: https://youtu.be/JgeUhXkxXbU