Forum Discussion

tinleyjj's avatar
tinleyjj
New Member
4 years ago
Solved

Return Text when RELATED Function has not match in related table

Hi,    When adding a column to a calculated table from another table using RELATED(),  I would like to return "Text" where there is no related ID in the second table. I can accomplish this through ...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    4 years ago

    tinleyjj 

    I think this is what you are looking for.

    Next_Enroll_Outcome = COALESCE ( Related('4_Enrollment'[Enroll_Inst_Outcome]), "3_StopOut" )
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
4 years ago

tinleyjj 

I think this is what you are looking for.

Next_Enroll_Outcome = COALESCE ( Related('4_Enrollment'[Enroll_Inst_Outcome]), "3_StopOut" )