DAX Fridays! #30: SEARCH vs FIND

In today's DAX Fridays! tutorial we are going to go though examples on how to use two DAX functions: SEARCH and FIND

SEARCH and FIND DAX functions are used to find the number of characters at which a specific word is found in a column.

00:58 SEARCH function DAX Microsoft Documentation
02:20 DAX search function without options
04:00 DAX search function with options
04:43 DAX search function Error validation options
05:49 DAX search function with * wildcard
07:00 DAX search function with ? wildcard
08:52 Search and Switch functions
10:35 Find function DAX Microsoft Documentation
10:57 Find function explained
11:32 Find vs Search function

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

ABOUT CURBAL:

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

#daxfridays #curbal #SUBSCRIBE

[williamarthur]

Thank you once again, for solving a problem in pointing out the Not found option not really being optional.

[tomtao]

I have used "Text.contains" in M for meeting similar goals. I am glad I have learnt another way. Thanks Curbal!

[murthysydney]

A great learning curve, Hope to see more videos, & How to look up a string in DAX. using related or related table.

[walidkhlil]

Again, and again. Thank you And we appreciate your effort.

[NorbertoVeraReatigaNVR]

Muy buena exposición del uso de estas dos funciones, lo pondré en practica inmediatamente en mis tableros!, Ruth como siempre muy agradecido por su aporte a nuestro conocimiento!!!

[UlyssesHaq]

love it!! Thank you for improving our computer geek lives hehe. X gracies!

[rajkumarioruganti]

Super explanation, It was of great help.

[gagansingh]

Mam your videos are so informative ....I just wanna see how all & filter function works when writing Dax on them please make one video giving example on Excel sheet ...

[SmartBimson]

Hey Ruth, again a very interesting video and I now have my weekend :-)))) thanks for the video and have a great weekend 👍🏻👍🏻👍🏻🎉☀☀☀

[dhess]

Awesome for someone who is just learning. Thank you.

[tnsparks]

What if you do not want to just search for a wildcard but also replace a found wildcard with another string. For example: I want to find anything with "tam" (so finds tami, tammie, tammy, etc) and I want to replace it with "Tamifay Smith". Is that possible?

[martinmejia]

Thanks, Ruth! Great video, as always! Can the text to be searched (the first parameter) be a different texts contained in a column in another table? For instance, if you have another table with a column with 2 rows, each one of them containing the texts "semilt and curbal", can you reference that table[column] to be searched into the Source column of the table you are showing? Thanks!

[SyedUsman]

awsum videos ruth, can u do step by step power query?

[mshparber]

Nice! What software do you use to record your screen with your voice? Thanks

[Babayagaom]

i want to split name column based on space delimiter without using power query, can you please help?

[Victor-ollo]

Great video Ruth !! I tried both function in PP but the result was not sufficient. If I use only one character within SEARCH or FIND it works, as soon as I add more characters I receive an error. I also tried to solve it via PQ with Text.contanins - same result. Do you have a hint how to solve the problem? Your feedback is highly appreciated.

[davida.taylor]

This is good, thank you! What if you wanted to search for text containing either "semalt" or "curbal"?

[joefromdc]

Question

What if I needed the first two numbers to start with “27” and then only show where there are four numbers after ( 27....). Total 6 numbers. How would I used the wildcard