Forum Discussion
Calculate average using only workdays excluding weekends/holidays
I need to calculate the average of an item by rolling 6 months usage but only during workdays. It has to exclude weekends and holidays This is the formula I use to calculate the rolling 6 month u...
Hi , AA622
Based on your description, you want to ask for the number of working days for a certain date range. Right?
You can try using the new NETWORKDAYS() function.
For more information , you can refer to the DAX document:
NETWORKDAYS function (DAX) - DAX | Microsoft Learn
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly