Non Working Days Calculation

Hi Ding_Dong43 ,

You can have a look at this blog to discount non working days.

https://www.sqlbi.com/articles/counting-working-days-in-dax/

https://www.youtube.com/watch?v=9M1V_m-oEzc&vl=en

https://businessintelligist.com/2018/12/04/working-with-workdays-in-power-bi-translating-workdays-into-dates/

Regards,

Harsh Nathani

A good approach for this is to make a Date table with an IsWorkingDay column based on your work week and then you can write a simple expression to count how many working days occur between two dates.  This video/article gives the details.

https://www.sqlbi.com/articles/counting-working-days-in-dax/

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat