Create Task EndDate but exclude weekends

Hi,

If you do not have a calendar dim table, please check the below picture and the attached pbix file.

It is for creating a calculated column.

Enddate CC =
VAR _mindate =
    MIN ( Data[StartDate] )
VAR _maxdate =
    DATE ( YEAR ( MAX ( Data[StartDate] ) ) + 1, 12, 31 )
VAR _calendartableexcludingsatsun =
    FILTER (
        ADDCOLUMNS (
            CALENDAR ( _mindate, _maxdate ),
            "@dayname", FORMAT ( [Date], "ddd" )
        ),
        NOT ( [@dayname] IN { "Sat", "Sun" } )
    )
VAR _count =
    ADDCOLUMNS (
        _calendartableexcludingsatsun,
        "@count",
            COUNTROWS (
                FILTER (
                    _calendartableexcludingsatsun,
                    [Date] >= Data[StartDate]
                        && [Date] <= EARLIER ( [Date] )
                )
            )
    )
RETURN
    SUMMARIZE ( FILTER ( _count, [@count] = Data[BuildTimeDays] ), [Date] )