Getting the latest value from two tables

Hi,

Please check the below picture and the attached pbix file.

From Opportunities CC =
VAR currentyear =
    YEAR ( Appointment[VISIT DATE] )
VAR currentcustomer = Appointment[CUSTOMER]
VAR opptable_bymaxdateyear =
    CALCULATETABLE (
        Opportunities,
        TREATAS (
            SELECTCOLUMNS (
                GROUPBY (
                    ADDCOLUMNS ( Opportunities, "@year", YEAR ( Opportunities[createdon] ) ),
                    Opportunities[CUSTOMER],
                    [@year],
                    "@maxdate_peryear", MAXX ( CURRENTGROUP (), Opportunities[createdon] )
                ),
                "@customer", Opportunities[CUSTOMER],
                "@create", [@maxdate_peryear]
            ),
            Opportunities[CUSTOMER],
            Opportunities[createdon]
        )
    )
VAR filtertable =
    FILTER (
        opptable_bymaxdateyear,
        YEAR ( Opportunities[createdon] ) = currentyear
            && Opportunities[CUSTOMER] = currentcustomer
    )
RETURN
    IF (
        NOT ISBLANK ( MAXX ( filtertable, Opportunities[STATUS] ) ),
        MAXX ( filtertable, Opportunities[STATUS] ),
        "No Opportunity"
    )