RELATED TABLE WITH CONDITION

[Diana_Jardim100]

Hello guys, 

I'm trying to crate a column with  information from another table.

I tried to do a lookup but I have some duplicates so it didn't work.

The condition is: 

IF the end date is blank , then keep blank, otherwise, bring the last information contained in the second table - column (ID_TERM_REASON) 

First  Table

 

Second table 

[Diana_Jardim100]

Many thanks.

It was exactly what I needed. 

[tamerj1 · Accepted solution]

Hi @Diana_Jardim100 
Please try

ID_TERM_REASON =
IF (
    NOT ISBLANK ( Table1[End Date] ),
    MAXX (
        TOPN ( 1, RELATEDTABLE ( Table2 ), Table2[Date] ),
        Table2[ID_TERM_REASON]
    )
)