How to search for email address consists of certain letter like "gmail"

[admin11]

Hi All 

i have list of email address , i like to flag those email with "gmail"

can some one share with me how to go about it ?

below link is my PBI :-

https://www.dropbox.com/s/kaq75i5s5f7usjg/DATABASE_V002.pbix?dl=0

Paul

[ryan_mayu · Accepted solution]

@admin11 

pls try this

Column = if(SEARCH("gmail",DATABASE_WIX[Email],1,0)<>0,"gmail")