cancel
Showing results for
Did you mean:
Helper I

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

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.

1 ACCEPTED SOLUTION
Community Support

Hi @Blondyvl ,

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.

2 REPLIES 2
Community Support

Hi @Blondyvl ,

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.

Community Champion

Hi @Blondyvl ,

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 🙂

Announcements