DAX Fridays! #180: Find text in columns using DAX

There are a lot of functions that allow you to search for text in a column using DAX and I have already shown you a few, but here is one more!

Search and find DAX function tutorial:

in, containsrow DAX function tutorial:

Containsstring, containsstringexact dax tutorial:


SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:


Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲


************





************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[leonidiakovlev]

I enjoy your every video. BTW, I like your attitude the most :) Have a great weekend everyone!

[atiry]

Each Friday I am very excited about your videos, and I watch them and enjoy. 😉 thanks Ruth, you are awesome.

[SayuriValente]

how could I vet if a column has at least one of the words in another word table (regardless of order)?

[lfvc]

Thanks! really helpful with no estructured data

[georgeomondi]

First viewer.!!!! another great tutorial

[emilyamalkin]

How do I let the users enter keywords (I use live connection, so cant do parameters, or build my own tables and columns). I can only use aggregate dax functions and visuals…

[unladpinoytv]

what if i need to compare them to multiple text

[joseagundis]

Gracias por explicarnos la sintaxis, a veces un poco confusa. Saludos Ruth y buen fin de semana.

[HarshNathani]

Thanks Ruth . It is helpful
A video on HASONEFILTER is also pending.

[joangarcia]

Interesante para una mente detectivesca 🧐

[narangichaudharyeeeee]

Please hindi ma'am i dont understand english