Enable an engine built in formula to calculate Excel equivalent of networking days: Number of business days between 2 dates, excluding weekends and bank holidays provided as an optional list of date...
Hi Conrad, We don't have this on the immediate backlog but it is pretty straightforward to do in DAX. This should do the trick if you want to filter out Saturday and Sunday: Measure = CALCULATE(COUNTROWS('Calendar'), FILTER('Calendar', WEEKDAY('Calendar'[Date]) > 1 && WEEKDAY('Calendar'[Date]) < 7 )) There are even easier ways to do this using a calculated column or Power Query where you add a column to check if a date is a working day. This will simplify the DAX above.
