Forum Discussion
Count total Work days in power query editor
Hi Please help me with get total working days count in query editor except Sat and Sun.
Anonymous
Assume you have Start Date and End Date in your table, add the following as a Custom Column:=List.Count( List.Select( List.Dates([Start Date], Number.From([End Date]-[Start Date])+1,#duration(1,0,0,0)), each Date.DayOfWeek(_,1) < 5 ) )________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy
Super User
Super UserAnonymous
Assume you have Start Date and End Date in your table, add the following as a Custom Column:
=List.Count(
List.Select(
List.Dates([Start Date], Number.From([End Date]-[Start Date])+1,#duration(1,0,0,0)),
each Date.DayOfWeek(_,1) < 5
)
)________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
Thank you So much