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