Forum Discussion

shefalinishad11's avatar
shefalinishad11
Helper I
5 years ago
Solved

Calculate task end date from task start date and project wise

Hey Community,   I am creating a milestone tracker, and I need little help here: Project Task Task Start Date Task End Date P1 T1 12/2/21 15/2/21 P1 T2 15/2/2...
Need Help
Tips and Tricks
  • Geradav's avatar
    Geradav
    5 years ago

    Here is an alternative adapted from amitchandak 

    EndDate_V2 =
VAR project = TableTasks[Project]
VAR TaskStartDate = TableTasks[TaskStartDate]
VAR nextTaskDate =
    MINX (
        FILTER (
            TableTasks,
            TableTasks[Project] = project
                && TableTasks[TaskStartDate] > TaskStartDate
        ),
        TableTasks[TaskStartDate]
    )
RETURN
    IF ( ISBLANK ( nextTaskDate ), TaskStartDate, nextTaskDate )
Geradav's avatar
Geradav
Responsive Resident
5 years ago

Here is an alternative adapted from amitchandak 

EndDate_V2 =
VAR project = TableTasks[Project]
VAR TaskStartDate = TableTasks[TaskStartDate]
VAR nextTaskDate =
    MINX (
        FILTER (
            TableTasks,
            TableTasks[Project] = project
                && TableTasks[TaskStartDate] > TaskStartDate
        ),
        TableTasks[TaskStartDate]
    )
RETURN
    IF ( ISBLANK ( nextTaskDate ), TaskStartDate, nextTaskDate )
  • shefalinishad11's avatar
    shefalinishad11
    Helper I
    5 years ago

    It worked, thank you so much to help.