Forum Discussion
Solved
Text.Startswith() with plural strings
Hi. How do I accomplish - using M - excluding all strings that begin with "xyz", "ab", any number, etc. It would be something like =Table.SelectRows(#"last step", each Text.StartsWith([column], ...
Hi GoingIncognito ,
You could use IF() and or/and to return your expected result.
Here is the similar case for your reference.
Hi GoingIncognito , try this
https://community.powerbi.com/t5/Service/List-as-input-criteria-for-Text-StartsWith/m-p/204257#M27491
Regards,
pceglie
I did actually look at it before postin a question because I thought my case is such an easy scenario that you could just insert a List.Contains or something in my example and make it work? Or am I completely wrong? Thank you for the link and all!