How to search for a string of characters

[pedroccamara]

Hello everyone

Is there a way of searching a person's name, for example, in the whole table and whole fields? How?

Best regards

Pedro

[ImkeF · Accepted solution]

Yes, you can use Table.FindText: https://msdn.microsoft.com/en-us/library/mt260782.aspx

this will return the row where the text is found

[ImkeF · Accepted solution]

Sure. Check out this video and come back if there is anything else that can help:

https://youtu.be/QGhULCWvySM

[ImkeF · Accepted solution]

Yes, you can use Table.FindText: https://msdn.microsoft.com/en-us/library/mt260782.aspx

this will return the row where the text is found

[pedroccamara]

Hello Imkef

Many thanks for your reply

Please can you be more specific?

Where can i use it and how? Is it in editor mode or...? Can i choose some kind of visualizations?

Can you help me please, cose it's a procedure that i'm doing too many times in a day...

Tks a lot

Best regards

Pedro

[v-ljerr-msft · Accepted solution]

Hi @pedroccamara,

In addition to ImkeF's solution, you can also use SEARCH Function (DAX) to create a calculate column within Modeling tab in this scenario. See my sample below.

Assume we have a table called "MyTestTable" like below.

1. Use the formula below to create a calculate column called "NameContainsBob" in "MyTestTable".

NameContainsBob = IF ( ISERROR ( SEARCH ( "Bob", MyTestTable[Name] ) ), "Other", "Bob" )

2. Then you should be able to use "NameContainsBob" column as a Slicer and show the data you want in the report.

Here is the sample pbix file for your reference.

Regards

[pedroccamara]

Hello ImkeF and JerryLi

I'm so lucky for this solution you've show me.

Gotta test them both monday. 

you're both awesome!

Tks a lot

Best regards

Pedro

[ImkeF · Accepted solution]

Sure. Check out this video and come back if there is anything else that can help:

https://youtu.be/QGhULCWvySM