Number of Working Days Able to Filter by Month

[Anonymous]

Hi,

I have created calculated columns to give me the number of working days since the "first entry" that an employee entered data into the system.

My calculated column calculates the number of days from the first date of entry, to todays date, and counts the number of week days between those two dates.

Is there a way to create a measure that allows me to filter the days by month?

So if I select March, the measure will search for the first date of entry in March by that employee, and subtract that date from todays date to get the accurate number of working days up until todays date?

Please let me know if this question does not make sense...

Thank you!
Sarh

[amitchandak]

@Anonymous , you can create a working day column in your calendar and that to sum up .

work day = if(weekday([date],2)<6,1,0)

[Anonymous · Accepted solution]

Hi @jdbuchanan71 and @amitchandak ,

I was able to find the number of working days, but was wondering if I could filter the number of working days by month, so if I use a filter in the dashboard, the nubmer of working days would also filter

Thank you!
Sarah

[jdbuchanan71]

@Anonymous 

You can but you have to do it using a calendar table and an isWorkingDay type of column then you do the sum against the caledar table and apply the filters from the calendar table.

[jdbuchanan71]

@Anonymous 

Take a look at this article that talks about calculating working days.  You will need a calendar table in your model.

https://www.sqlbi.com/articles/counting-working-days-in-dax/