Create a calculated column by comparing two dates from different tables in DirectQuery

Hi data_operador1 

Are both tables in DirectQuery mode? I'm afraid it's not possible to add this calculated column to a DirectQuery table as it will hit the following model limitation of DirectQuery. 

Limitations in calculated columns: Calculated columns are limited to being intra-row, as in, they can only refer to values of other columns of the same table, without the use of any aggregate functions. See About using DirectQuery in Power BI. 

Instead, you can try using a measure to get the expected date result. Remember to add 'Table 1'[ID] and 'Table 1'[CODE] to the same visual as well as the measure. 

Date =
IF (
    ISBLANK ( SELECTEDVALUE ( 'Table 1'[FECHA1] ) ),
    CALCULATE (
        SELECTEDVALUE ( 'Table 1'[FECHA1] ),
        FILTER (
            ALL ( 'Table 2' ),
            'Table 2'[ID] = MAX ( 'Table 1'[ID] )
                && 'Table 2'[CODE] = MAX ( 'Table 1'[CODE] )
        )
    ),
    SELECTEDVALUE ( 'Table 1'[FECHA1] )
)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.