Count total Work days in power query editor

[Amardeep100115]

Hi 

Please help me with get total working days count in query editor except Sat and Sun.

[amitchandak]

@Amardeep100115 , refer to this, how to get net work days https://www.thebiccountant.com/2020/02/20/date-networkdays-function-for-power-query-and-power-bi/

[Fowmy · Accepted solution]

@Amardeep100115 

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 🙂

Website YouTube  LinkedIn

[Amardeep100115]

Thank you  So much