Forum Discussion

Diana_Jardim100's avatar
Diana_Jardim100
Frequent Visitor
3 years ago
Solved

RELATED TABLE WITH CONDITION

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...
  • tamerj1's avatar
    tamerj1
    3 years ago

    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]
    )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

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]
    )
)