Forum Discussion
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 which gives me the number of working days in each month but how do I get the number of working days worked to the current date
i.e this month to date they have been 9 workings days
please try this
THISMONTHWORKDAY = CALCULATE(COUNTROWS('DATE'),FILTER('DATE','DATE'[Date]<=TODAY()&&'DATE'[WORKDAY2]="WEEKDAY"))
5 Replies
Killingworth , Refer this how to get working dates between 2 dates. Make one of the date as today.
Refer 2nd page
https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0
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"))
