undefined

Hi caruso1058 - see this measure:

Finish Date = 
VAR varCurrentDate = MAX('Table'[Start_Date])
VAR varNextDate = 
CALCULATE(
    MIN('Table'[Start_Date]),
    FILTER(
        All('Table'),
        'Table'[Start_Date] > varCurrentDate
    )
)
RETURN
IF(
    ISBLANK(varNextDate),
    varCurrentDate,
    varNextDate
    )

This will return the minium date above the current date, unless there is no next date, in which case it will repeat the current date.

One note caruso1058 - you didn't specify, but I assume you want this to be by project. Note the replacement of ALL() with ALLEXCEPT()

So you can see that the April 1, 2020 date did not impact the  A123 project.

Hi,

Try this calculated column formula

=calculate(min(data[project schedule]),filter(data,data[project]=earlier(data[project])&&data[project schedule]>earlier(data[project schedule])))

Hope this helps.