Week days count to show me only working days from a start date and end date collumn.

[Anonymous]

I'm trying to find how to create a weekday count for dates in a start date and end date column. I have used Dattedif for the total days between the dates, however I only want the working days, Monday to Friday.  Please can you help me.  Many thanks.

[v-eqin-msft · Accepted solution]

Hi @Anonymous ,

I have created dummy data for test:

In this case, we need to firstly create a new Calendar table:

Calendar = CALENDAR(MIN('Table'[Start Date]),MAX('Table'[End Date])) 

Then create a measure to calculate the count of working days:

Working Days =
CALCULATE (
    COUNTROWS ( 'Calendar' ),
    FILTER (
        'Calendar',
        [Date] >= MAX ( 'Table'[Start Date] )
            && [Date] <= MAX ( 'Table'[End Date] )
            && WEEKDAY ( [Date], 2 ) IN { 1, 2, 3, 4, 5 }
    )
)

Output:

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

[tackytechtom]

Hi @Anonymous ,

Here a similar thread. You can find various other links in there that I am sure will be helping you!

Working days between two dates - simply! - Microsoft Power BI Community

And here a video with a function in Power Query:

PowerBI: Calculate business/working days between two dates in a new column - YouTube

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/