Working Days

[Killingworth]

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

[ryan_mayu]

@Killingworth 

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.

[Killingworth]

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 ?

[ryan_mayu · Accepted solution]

@Killingworth 

please try this

THISMONTHWORKDAY = 
CALCULATE(COUNTROWS('DATE'),FILTER('DATE','DATE'[Date]<=TODAY()&&'DATE'[WORKDAY2]="WEEKDAY"))

[Killingworth]

That worked thanks for your help

[amitchandak]

@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