Calculate work days elapsed for all rows of my data?

[Anonymous]

I created a working days table that identifies each day of the year 2021 as a working day or not using @amitchandak's example here from 2020

Here's what my date table now looks like:

My objective is to create a measure that calculates the number of working days elapsed from one date, to the current date. Here's an example below of what I'm trying to achieve

Latest Submission Date is my data, that I need to subtract from the current date, but only counting working days

Latest Submission Date	New measure here: working days elapsed
1/20/2021	??
1/21/2021	??
1/22/2021	??
1/23/2021	??
1/19/2021	??
1/1/2021	??

[v-yuaj-msft · Accepted solution]

Hi @Anonymous ,

Based on your description, you can create a measure as follows.

working days elapsed =
VAR x1 =
FILTER (
ALL ( 'calendar' ),
[Date] <= TODAY ()
&& [Date] >= SELECTEDVALUE ( 'Submit'[Latest Submission Date ] )
&& WEEKDAY ( [Date], 2 ) < 6
)
RETURN
COUNTROWS ( x1 )

Today is 2/22/2021.

Result:

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Try a new measure

Work Day = COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR(max(Table[Latest Submission Date]),TODAY()),"WorkDay", if(WEEKDAY([Date],2) <6,1,0)),[WorkDay] =1))