DAX - Generate

Hi RobbeVL90 ,

Please update the formula of calculated table as below and check if it can return the expected result... Please find the details in the attachment.

EVALUATE
VAR Today =
    TODAY ()
VAR MaxTerms =
    DATEDIFF ( MIN ( 'DIM_SalesforceProject'[GoLiveDate] ), Today, YEAR )
RETURN
    ADDCOLUMNS (
        GENERATE (
            GENERATESERIES ( 1, MaxTerms ),
            SELECTCOLUMNS (
                'DIM_SalesforceProject',
                "Contract_StartDate", 'DIM_SalesforceProject'[GoLiveDate],
                "ProjectCode", 'DIM_SalesforceProject'[ProjectCode]
            )
        ),
        "Term_StartDate",
            EDATE ( [Contract_StartDate], ( [Value] - 1 ) * 12 ),
        "Term_EndDate",
            EDATE ( [Contract_StartDate], [Value] * 12 ) - 1
    )

Best Regards