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"
)
Jasonk-WP43's avatar
Jasonk-WP43
New Member
4 years ago

I have an Excel sheet with customer order details, I would like to calculate the following:

  • Number of registered customers since starting the online store (Just the number of customers to date)
  • Top cities or areas within the city that ordered

  • Total Unit Sales and Total Revenue

     

How can I achieve this 

 

Thanks in advance