Forum Discussion

chethan's avatar
chethan
Icon for Resolver III rankResolver III
9 years ago

Date Duration exclude weekends

Hi All,   i need a DAX formula to calculate the Date Duration by Excluding the Weekends (Saturday & Sunday) Below is the Table View.   TableName : WeeklyReport   Please help on this    Ord...
v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

chethan

 

If you also want to exclude non-working hours, you can take a look at this thread, and transfer the hours to days.

 

Best Regards,

Herbert