Forum Discussion
Filter Table by Text Found Within Field
Hi All!
So I have a table that contains two fields. One field is a text field where I am trying to extract an alphabetized list of keywords. The other field is a value associated with the text. The image below should help describe:
I would like to be able to filter the source text by the keywords that are found inside of it. It doesn't need to have any particular order, but all keywords must be found inside of the text. In the example above, you should not be able to filter by just "dog".
The keywords are always led by "keyword=", are separated by commas, and always end with a &. Does anyone know of any way that I can organize my data so that I can filter in a way that order does not matter?
Thanks!!
I'm not sure I understand what you want to achieve - do you want the filter to work as the visual or in the data transformations?
for the transformations you could try with extracting the keywords in M as a list and then filtering with List.ContainsAll
https://docs.microsoft.com/en-us/powerquery-m/list-containsall
1 Reply
- Stachu
Community Champion
I'm not sure I understand what you want to achieve - do you want the filter to work as the visual or in the data transformations?
for the transformations you could try with extracting the keywords in M as a list and then filtering with List.ContainsAll
https://docs.microsoft.com/en-us/powerquery-m/list-containsall