ENCONTRAR UNA PLABRA CLAVE EN VARIOS CAMPOS (FIND A KEYWORD IN MULTIPLE FIELDS)

[avaldiviezo]

HOLA, TENGO VARIOS CAMPOS QUE TIENEN PALABRAS COMO "SI", "NO", "SI,NO"   , NECESITO CREAR UN CAMPO NUEVO PARA LAS PERSONAS QUE ALMENOS HAYAN RESPONDIDO UN "SI", ME PODRIAN AYUDAR CON LA FORMULA 

(HELLO, I HAVE SEVERAL FIELDS THAT HAVE WORDS LIKE "YES", "NO", "YES, NO", I NEED TO CREATE A NEW FIELD FOR PEOPLE WHO HAVE AT LEAST ANSWERED "YES", COULD YOU HELP ME WITH THE FORMULA)

[v-jingzhang · Accepted solution]

Hi @avaldiviezo 

You can create a new column with below DAX. 

New Column = IF(CONTAINSSTRING([Column1]&","&[Column2]&","&[Column3], "SI"), "SI", "NO")

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.