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,
It will help if you share data in an MS Excel workbook and show the expetced result there via formulas. One can then translate those Excel formulas into DAX formulas.