Help Making Calculated Columns and Gantt Chart

Hi MaironDominguez,

You can try to use following calculated column formulas if they suitable for your requirement:

AR Days = 
IF (
    Table1[Ticket Status] <> "Resolved",
    CALCULATE (
        SUM ( Table1[Estimated Resolving Days] ),
        FILTER (
            Table1,
            [ITStaff] = EARLIER ( Table1[ITStaff] )
                && [Ranking] <= EARLIER ( Table1[Ranking] )
                && [Ticket Status] <> "Resolved"
        )
    )
)

SDate = 
VAR cum =
    CALCULATE (
        SUM ( Table1[Estimated Resolving Days] ),
        FILTER (
            Table1,
            [ITStaff] = EARLIER ( Table1[ITStaff] )
                && [Ranking] < EARLIER ( Table1[Ranking] )
                && [Ticket Status] <> "Resolved"
        )
    )
RETURN
    IF ( Table1[Ticket Status] <> "Resolved", [Today] + cum )

EDate = 
IF (
    Table1[Ticket Status] <> "Resolved",
    [SDate] + [Estimated Resolving Days]
)

Notice: if you want these date dynamic changes based system date, you can replace the [Today] column to TODAY() function.

Regards,
Xiaoxin Sheng