Forum Discussion

BW617's avatar
BW617
New Member
7 years ago
Solved

Need help after calculating date difference excluding weekends.

So I have a calculation comparing number of working days between two dates. I have a date table and the calculation works just fine.   CycleTimexWeekends = CALCULATE(SUM(CalendarTable[WorkingDay]),...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    Perhaps:

     

    CycleTimexWeekendsCorrected = 
VAR __cycleTime = CALCULATE(SUM(CalendarTable[WorkingDay]),DATESBETWEEN(CalendarTable[Date],Data[Date_Of_Receipt_Formula],Data[Original_Date_of_Response]))
RETURN
IF(Data[Date_Of_Receipt_Formula] = Data[Original_Date_of_Response]),0,__cycleTime)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

Perhaps:

 

CycleTimexWeekendsCorrected = 
VAR __cycleTime = CALCULATE(SUM(CalendarTable[WorkingDay]),DATESBETWEEN(CalendarTable[Date],Data[Date_Of_Receipt_Formula],Data[Original_Date_of_Response]))
RETURN
IF(Data[Date_Of_Receipt_Formula] = Data[Original_Date_of_Response]),0,__cycleTime)