Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculated Column

Hey all, I've got a column containing e-mail adresses. I need to categorize this into three groups: An e-mail containing the string "unknown" should be categorized as "unknown" An empty cell sho...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 

    Try

    Type E-mail =
SWITCH (
    TRUE (),
    CONTAINSSTRING ( 'Data'[e-mail], "*onbekend*" ), "unknown",
    'Data'[e-mail] = BLANK (), "unknown",
    CONTAINSSTRING ( 'Data'[e-mail], "*jnj*" ), "business",
    "private"
)
johnt75's avatar
johnt75
Super User
4 years ago

Check that the cells are truly empty as opposed to having an empty string or a space character or something