Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Solved! Go to 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.
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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.