Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
User | Count |
---|---|
45 | |
25 | |
21 | |
18 | |
18 |
User | Count |
---|---|
51 | |
45 | |
24 | |
24 | |
21 |