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...
ssvr's avatar
ssvr
Icon for Helper III rankHelper III
8 years ago

Hi Anonymous ,

 

For which field (OpenDate or ClosedDate)  i have to create a column with IsWeekday function

 

Here we have only two date fields OpenDate  &  CloseDate

Anonymous's avatar
Anonymous
Not applicable
8 years ago

ssvr This proposed solution is based on the assumption that you have a separate date table. And it's for that date table you create the IsWeekday column, not for the OpenDate or the CloseDate in your fact table.

 

Br,

Magnus