I have a scenario where number of days between start and end date excluding weekends has to be calculated for each person in the data set. The calculation is a bit straightforward for those who have only one record or row in the dataset but more complicated when an individual has more than one reco…

Hi @bimbbb , Thanks for testing. It’s all about context in which you want to use this formula. I have updated formula to get total right. [image] It will be for individual rows if you have start date & end date in table as these 2 are different dates. However, if you do not have startdate & lastd…

Dax Calculation for Number of Days excluding weekends and holidays

DAX DAX Calculations

mickeydjw February 20, 2020, 9:47pm 2

You can use the formula here to determine weekdays versus weekends, then go from there:

Answer brilliantly stolen from @BrianJ’s reply on that post