Status column based on another table

Hi,

Please check the below picture and the attached pbix file.

Status CC =
VAR _currentproject = Projects[Project]
VAR _latestdate =
    MAXX ( RELATEDTABLE ( Statuses ), Statuses[Date] )
RETURN
    CALCULATE (
        MAX ( Statuses[Status] ),
        Statuses[Date] = _latestdate,
        Statuses[Project] = _currentproject
    )