Forum Discussion
Working days column from Date Column
I have a data table that contains a Start Date and I want a column called Target Date which is 30 working days from the Start Date. I also have a calendar table which I can connect to the Start Date...
spandy34 try this, add new column:
Target Date =
VAR __TargetDays = 30
VAR __StartDate = Table[Start Date]
VAR __TargetDate = __StartDate + __TargetDays
VAR __TargetDateWeekDay = WEEKDAY ( __TargetDate, 3 )
VAR __AddDays = IF ( __TargetDateWeekDay IN { 5, 6 }, 7 - __TargetDateWeekDay, 0 )
VAR __TargetWorkingDate = __TargetDate + __AddDays
RETURN __TargetWorkingDate Thank you for responding. So I have put the following in the column but it is calculating 30 days and including weekends. Is the Date in line 3 supposed to be from my date table or as outlined below, from the Caseload Oversight'[ASMStartDate] field?
