Help with a Calculated Column

Hi MaironDominguez ,

Due to today is 8/7/2023, here I use 8/4/2023 as today to have a test to try to get the result you want.

StartDate = 
VAR _TODAY =
    DATE ( 2023, 08, 04 )
RETURN
    IF (
        Table1[Ranking] = 1,
        _TODAY,
        _TODAY
            + CALCULATE (
                SUM ( Table1[Estimated Resolving Time (Days)] ),
                FILTER (
                    ALLEXCEPT ( Table1, Table1[ITStaff] ),
                    Table1[Ranking] < EARLIER ( Table1[Ranking] )
                )
            )
    )

EndDate = Table1[StartDate]+Table1[Estimated Resolving Time (Days)]

Result is as below.

If you want to dynamic today value, you can replace DATE(2023,08,04) by TODAY().

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.