Thank you once again, for solving a problem in pointing out the Not found option not really being optional.
@tomtao6098
7 жыл бұрын
I have used "Text.contains" in M for meeting similar goals. I am glad I have learnt another way. Thanks Curbal!
@CurbalEN
7 жыл бұрын
+Tom Tao Hi Tom, that's correct! Search can be useful to create conditional DAX measures. Glad you liked it ;) /Ruth
@bradj229
3 жыл бұрын
Thanks Ruth!
@laurastreckert7502
2 жыл бұрын
thank you, Thank You, THANK YOU!!!!
@CurbalEN
2 жыл бұрын
🎉🎉
@NorbertoVeraReatigaNVR
7 жыл бұрын
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!!!
@CurbalEN
7 жыл бұрын
+Norberto Vera Reatiga Muchas gracias Norberto, todo un placer :) /Ruth
@walidkhlil2872
4 жыл бұрын
Again, and again. Thank you And we appreciate your effort.
@CurbalEN
4 жыл бұрын
And thanks for all your support!
@murthysydney4372
7 жыл бұрын
A great learning curve , Hope to see more videos, & How to look up a string in DAX. using related or related table.
@CurbalEN
7 жыл бұрын
+Murthy Sydney Great idea Murthy, it is in my to do list now ;) /Ruth
@Devloper56
2 жыл бұрын
Wonderful!!!!!!!!
@CurbalEN
2 жыл бұрын
👏👏👏
@dhess5312
6 жыл бұрын
Awesome for someone who is just learning. Thank you.
@CurbalEN
6 жыл бұрын
Perfect! Thanks for the feedback ! /Ruth
@UlyssesHaq
4 жыл бұрын
Amaaaaaaazing, love it!! Thank you for improving our computer geek lives hehe. X gracies!
@CurbalEN
4 жыл бұрын
De nada! :) /Ruth
@rajkumarioruganti5364
4 жыл бұрын
Super explanation, It was of great help.
@tnsparks
2 жыл бұрын
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?
@gagansingh3481
2 жыл бұрын
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
7 жыл бұрын
Hey Ruth, again a very interesting video and I now have my weekend :-)))) thanks for the video and have a great weekend 👍🏻👍🏻👍🏻🎉☀☀☀
@CurbalEN
7 жыл бұрын
+SmartBimson Same to you Andy! Did you visit Sweden? /Ruth
@SmartBimson
7 жыл бұрын
Curbal yes I did, was great esp the people are very kind and smart ! And it was snowing ... a lot .
@CurbalEN
7 жыл бұрын
+SmartBimson Oh, in Stockholm? /Ruth
@SmartBimson
7 жыл бұрын
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)
@CurbalEN
7 жыл бұрын
+SmartBimson No worries, next time. Have a nice weekend :) /Ruth
@Babayagaom
4 жыл бұрын
i want to split name column based on space delimiter without using power query , can you please help?
@chescov
5 жыл бұрын
Amazing Ruth! :)
@CurbalEN
5 жыл бұрын
Yey!! Thanks:) /Ruth
@martinmejia197
6 жыл бұрын
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!
@thegodisland2179
6 жыл бұрын
Love Your Accent :)
@CurbalEN
6 жыл бұрын
Thanks :) Swespanglish 😂 /Ruth
@Victor-ol1lo
7 жыл бұрын
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.
@CurbalEN
7 жыл бұрын
+Victor Friesen Hi Victor, can you explain in more detail what is the problem you are trying to solve? /Ruth
@Victor-ol1lo
7 жыл бұрын
I just checked Excel 2016 & PowerBi - > it works perfectly. It seems to be a problem with my Excel 2010 version. Thanks and best regards.
@CurbalEN
7 жыл бұрын
+Victor Friesen ah, ok good to know! /Ruth
@stevennye5075
5 жыл бұрын
excellent
@CurbalEN
5 жыл бұрын
Are you watching them all? /Ruth
@mshparber
7 жыл бұрын
Nice! What software do you use to record your screen with your voice? Thanks
@CurbalEN
7 жыл бұрын
+Michael Shparber Hi Michael, I use Camtasia. Really easy to use :) /Ruth
@mshparber
7 жыл бұрын
Thanks!
@CurbalEN
7 жыл бұрын
+Michael Shparber My pleasure :) /Ruth
@joefromdc
5 жыл бұрын
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
@CurbalEN
5 жыл бұрын
Could you please ask in the power bi community? Thanks! /Ruth
@joefromdc
5 жыл бұрын
Curbal Thanks for ur reply, can you provide a link pls
@CurbalEN
5 жыл бұрын
Sure: community.powerbi.com /Ruth
@joefromdc
5 жыл бұрын
Curbal Posted my question, appreciate any help
@SyedUsman
7 жыл бұрын
awsum videos ruth , can u do step by step power query?
@CurbalEN
7 жыл бұрын
+Syed Ahmed Hi Syed, Sure, I will put on my list. Anything in particular you want to see? /Ruth
@davida.taylor8444
5 жыл бұрын
This is good, thank you! What if you wanted to search for text containing either "semalt" or "curbal"?
@CurbalEN
5 жыл бұрын
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
Пікірлер: 54