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"))
It will be better that you share your measure and the sample data.
THISMONTHWORKDAY =
VAR mth=MONTH(TODAY())
VAR yr=YEAR(today())
RETURN CALCULATE(COUNTROWS('DATE'),FILTER('DATE',YEAR('DATE'[Date])=yr&& MONTH('DATE'[Date])=mth&&'DATE'[Date]<=TODAY()&&'DATE'[WORKDAY2]="WEEKDAY"))Since my local time is about 1 am, my workday is 10 for this month.
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