Forum Discussion
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...
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:
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,
Tahreem24
Super User
Super UserAnonymous ,
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: