Calculated column

Hi smiler2021 ,

My example data:

[AcutalTable]

[BudgetTable]

try this dax to creata a new column:

Column =
VAR _a =
    CALCULATE(
        MAX( 'AcutalTable'[description] ),
        FILTER(
            AcutalTable,
            [ProjectID] = EARLIER( 'Dim Project Numbers'[ProjectID] )
        )
    )
VAR _b =
    CALCULATE(
        MAX( 'BudgetTable'[description] ),
        FILTER(
            BudgetTable,
            [ProjectID] = EARLIER( 'Dim Project Numbers'[ProjectID] )
        )
    )
RETURN
    IF( ISBLANK( _a ), _b, _a )

 and result:

I put my pbix file in the attachment you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.