DAX Fridays! #30: SEARCH vs FIND
Vložit
- čas přidán 3. 07. 2024
- 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.
Link to Power BI file used in the video: curbal.com/blog/glossary/sear...
curbal.com/blog/glossary/find...
EXCEL SURVEY: 1drv.ms/xs/s!Ar8CDNp8cGTcgjaH...
PREVIOUS VIDEO - HASONEVALUE: • DAX Fridays! #29: HASO...
NEXT VIDEO: • DAX Fridays! #31: Roun...
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
Looking for a download file? Go to our Download Center: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: goo.gl/rvIBDP
► Facebook: goo.gl/bME2sB
#daxfridays #curbal #SUBSCRIBE
► Linkedin: goo.gl/3VW6Ky
Thank you once again, for solving a problem in pointing out the Not found option not really being optional.
I have used "Text.contains" in M for meeting similar goals. I am glad I have learnt another way. Thanks Curbal!
+Tom Tao Hi Tom, that's correct! Search can be useful to create conditional DAX measures.
Glad you liked it ;)
/Ruth
Again, and again. Thank you And we appreciate your effort.
And thanks for all your support!
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!!!
+Norberto Vera Reatiga Muchas gracias Norberto, todo un placer :)
/Ruth
Amaaaaaaazing, love it!! Thank you for improving our computer geek lives hehe. X gracies!
De nada! :)
/Ruth
Super explanation, It was of great help.
A great learning curve , Hope to see more videos, & How to look up a string in DAX. using related or related table.
+Murthy Sydney Great idea Murthy, it is in my to do list now ;)
/Ruth
Thanks Ruth!
Amazing Ruth! :)
Yey!! Thanks:)
/Ruth
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!
thank you, Thank You, THANK YOU!!!!
🎉🎉
Wonderful!!!!!!!!
👏👏👏
Awesome for someone who is just learning. Thank you.
Perfect! Thanks for the feedback !
/Ruth
Hey Ruth, again a very interesting video and I now have my weekend :-)))) thanks for the video and have a great weekend 👍🏻👍🏻👍🏻🎉☀☀☀
+SmartBimson Same to you Andy! Did you visit Sweden?
/Ruth
Curbal yes I did, was great esp the people are very kind and smart ! And it was snowing ... a lot .
+SmartBimson Oh, in Stockholm?
/Ruth
Curbal yes .. close to ;-) Last weeks Tuesday. And that's why there was no time for a coffee :-( due to snow I took a taxi 1,5 hours earlier to the airport (Accidents and so on)
+SmartBimson No worries, next time. Have a nice weekend :)
/Ruth
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 ...
Love Your Accent :)
Thanks :)
Swespanglish 😂
/Ruth
excellent
Are you watching them all?
/Ruth
i want to split name column based on space delimiter without using power query , can you please help?
This is good, thank you! What if you wanted to search for text containing either "semalt" or "curbal"?
If or switch should help depending on what you are trying to do. Post in the power bi community for more detail help, thanks!
/Ruth
awsum videos ruth , can u do step by step power query?
+Syed Ahmed Hi Syed,
Sure, I will put on my list. Anything in particular you want to see?
/Ruth
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?
Nice! What software do you use to record your screen with your voice? Thanks
+Michael Shparber Hi Michael, I use Camtasia. Really easy to use :)
/Ruth
Thanks!
+Michael Shparber My pleasure :)
/Ruth
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.
+Victor Friesen Hi Victor, can you explain in more detail what is the problem you are trying to solve?
/Ruth
I just checked Excel 2016 & PowerBi - > it works perfectly. It seems to be a problem with my Excel 2010 version. Thanks and best regards.
+Victor Friesen ah, ok good to know!
/Ruth
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
Could you please ask in the power bi community? Thanks!
/Ruth
Curbal
Thanks for ur reply, can you provide a link pls
Sure: community.powerbi.com
/Ruth
Curbal
Posted my question, appreciate any help