Forum Discussion
Solved
Working Days
I have two tables 1. With raw data of interactions broken down by date 2. Date table with all dates of the year with an indicator if the day is a working day or not. I have a measure whic...
please try this
THISMONTHWORKDAY = CALCULATE(COUNTROWS('DATE'),FILTER('DATE','DATE'[Date]<=TODAY()&&'DATE'[WORKDAY2]="WEEKDAY"))
That gives me the number of working days complete in the current month but if I filter the data for previous months it doesn't give the amount of working days complete in the filtered month ?
please try this
THISMONTHWORKDAY =
CALCULATE(COUNTROWS('DATE'),FILTER('DATE','DATE'[Date]<=TODAY()&&'DATE'[WORKDAY2]="WEEKDAY"))
That worked thanks for your help