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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hey Johnt75. I did check them for spaces or something. The cells are truly empty.

    • johnt75's avatar
      johnt75
      Super User
      4 years ago

      There doesn't appear to be anything wrong with the SWITCH statement. You could add a new column

      Is Blank = ISBLANK ( 'Data'[e-mail] )

      and see if that gives the expected results