Forum Discussion

mterry's avatar
mterry
Helper V
8 years ago
Solved

Catch-all when no reference

I have a data table that has various info on it, all linked to location codes. I have a separate reference table that links those location codes to the common names of the locations. Sometimes there ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    mterry

     

    Hi, You can use a calculated column like this

     

    Location =
IF (
    RELATED ( Table2[Location] ) = BLANK ();
    "Misc";
    RELATED ( Table2[Location] )
)

    Regards

     

    Victor

    Lima - Peru

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Try this

 

=IF(ISBLANK(RELATED(Table1[Location])),BLANK(),RELATED(Table1[Location]))

 

Hope this helps.

mterry's avatar
mterry
Helper V
8 years ago

Thank you both for the help, it worked