Forum Discussion
Solved
List dates between Start & End date excluding weekends
Hello, I have a dataset of construction schedule (more than 3400 tasks), which have all the information task wise (start/end dates, total resources/workforce numbers allocated for that task, etc....
You can approach this two ways. In another column, add this formula:
Date.DayOfWeek([Date], Day.Saturday)That will mark Saturday as 0, Sunday as 1, and Mon-Fri as 2-6. Now, either filter out days < 2, or add "<2" to the end, that will return True for weekends and False for weekdays.
Now filter that out, or using DAX, you can count the days excluding the TRUE values for weekends.
You can approach this two ways. In another column, add this formula:
Date.DayOfWeek([Date], Day.Saturday)That will mark Saturday as 0, Sunday as 1, and Mon-Fri as 2-6. Now, either filter out days < 2, or add "<2" to the end, that will return True for weekends and False for weekdays.
Now filter that out, or using DAX, you can count the days excluding the TRUE values for weekends.