Text.Startswith() with plural strings

[GoingIncognito]

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], "") = false ) ?

Inserting false would exclude all the values? But how do I replace "" with a list of values? 

Thank you!

[v-eachen-msft]

Hi @GoingIncognito ,

Has your problem been solved? If the problem has been solved, you could accept the reply you like.

[v-eachen-msft · Accepted solution]

Hi @GoingIncognito ,

You could use IF() and or/and to return your expected result.

Here is the similar case for your reference.

https://community.powerbi.com/t5/Desktop/M-Query-Editor-Trouble-with-Conditional-IF-statement/m-p/96...

[pceglie]

Hi @GoingIncognito , try this
https://community.powerbi.com/t5/Service/List-as-input-criteria-for-Text-StartsWith/m-p/204257#M2749...

Regards,

pceglie

[GoingIncognito]

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!