Forum Discussion
Date Difference excluding weekends
Hello, I have a starting date and an ending date and I need to count only the working days in between. In other words, the date difference (DATEIFF) between the ending and the starting without tak...
Something like this:
[Date Diff Measure] =
VAR Created =
MAX ( Table[CreatedDate] )
VAR Closed =
MAX ( Table[ClosedDate] )
RETURN
CALCULATE (
SUM ( 'Dim Table'[is work day] ),
FILTER (
ALL ( 'Dim Table'[DateColumn] ),
'Dim Table'[DateColumn] >= Created
&& 'Dim Table'[DateColumn] <= Closed
)
)
Anonymous
some error in DAX