Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I've seen a few suggestions but none of them are working.
I want to create a calculated column, searching another column containing email addresses for text string "@company"
So I was thinking of a 'CONTAINS' argument or similar.
Attached image is my desired result.
The purpose of this is so I can identify work email addresses.
Thanks in advance for any suggested DAX!
Solved! Go to Solution.
Hi,
use the below calculation by creating new column
Accept this as solutions if it works for you.
Regards
Harsha
Hi,
use the below calculation by creating new column
Accept this as solutions if it works for you.
Regards
Harsha
Well what do you know @Anonymous it worked perfectly.
Thank you!!!!!
you could try using the split column functionality in the query editor to seperate what is before and after the '@' , then create the calculated column with your desired result.
I'm hopeful I can find a DAX measure that will be able to look within a text string for specific text, but if it transpires this isn't possible I guess I can start splitting the column.
Thanks for the suggestion!
Hey,
I have a table that contains all the email domains that make an email private, this table looks like this and is called searchphrases:
I also have a table that contains a column with email addresses, this table is called "look at" and looks like this:
I use this DAX to create a calculated column in the table "look at":
is company email = var findwithin = 'look at'[email] var findthese = VALUES('searchphrases'[searchphrase]) var found = SUMX( findthese , var findthis = [searchphrase] return IF(FIND(findthis , findwithin , 1 , 0) = 0 , BLANK() , 1 ) ) return IF(ISBLANK(found) , "Y" , "N")
Then the table "look at" will look like this:
Hopefully this is what you are looking for.
Regards,
Tom
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |