Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Open days to count ?

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(DISTINCT...
Interesting Links
Need Help
Tips and Tricks
  • Tahreem24's avatar
    Tahreem24
    5 years ago

    Anonymous ,

    Suppose you have Date Column with Date format so create a new Calculated Column like below:

    WeekdayFlag = if(weekday('Calendar'[Date]) = 1,0,if(weekday('Calendar'[Date])=7,0,1))
    Then take only Month in table and above calculated column so you'll something like below:
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

 

Regards,

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous 

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