Search values in "Mail" column

[propionic]

Hi all,

In Power Bi i do not find how to use function on an email column

ex: To make difference of Internal and external people of my company, the "-ext" is added to the email

Email	Internal
toto@mycompany.com	true
toto-ext@mycompany.com	false
test@mycompany.com	true

I used the CONTAINS function but does not work with "Email" column.. any idea??

External User = CONTAINS(Users,Users[email], "-ext")

Thanks you for your help.

[malagari · Accepted solution]

Check out this post: https://community.powerbi.com/t5/Desktop/If-text-column-CONTAINS-specified-value-give-me-what-I-want...

Rather than using CONTAINS, you can use SEARCH and return True/False in the conditional IF statement.

[v-qiuyu-msft · Accepted solution]

Hi @propionic,

You can also use Find() function to create a calculated column below: 

Internal = IF(FIND("-ext",'Table2'[Email],,BLANK())>0,FALSE(),TRUE())

Best Regards,
Qiuyun Yu 

[malagari · Accepted solution]

Check out this post: https://community.powerbi.com/t5/Desktop/If-text-column-CONTAINS-specified-value-give-me-what-I-want...

Rather than using CONTAINS, you can use SEARCH and return True/False in the conditional IF statement.