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. Th...
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
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