Sum error on text function

Hi EMauterer,

This has to be something obvious I'm missing.  I'm trying to create a new text column that pulls a text value from a different table, and populates the column with a text string if the lookup is not found in the other table. 

---

What's the relationship between the two tables? If there is a many to one(*:1) relationship between your current table you want to add the new column into and your "Channel" table, then the formula below should work in your scenario.

CustomerChannel =
IF (
    ISBLANK ( RELATED ( 'Channel'[Channel] ) ),
    "Wholesale",
    RELATED ( 'Channel'[Channel] )
)

If that is not the case, please post your table structures with some sample data and your expected result. :smileyhappy:

Regards