Filter List (does not start with)

[Chrisjr]

Hello All,

I have transform a table into a list. 

What I am trying to do is to tell PBI not to take columns that start with "P_"

The idea is to use the funciton below: 

= List.Select( Table.ColumnNames(#"Changed Type"), each Text.StartsWith(_, "P_"))

But instead of saying "Text.StartsWith(_, "P_")" , I want to say "Text does not stats with (_, "P_")".

How could I achieve that ? 

Thank you

[Chrisjr]

thanks @watkinnc 

[watkinnc · Accepted solution]

each not Text.StartsWith(...)

--Nate