How to structure an exclusion array?

[UsePowerBI]

Hello

Is it possible to structure an array of all values excluding specific values?

I.e. I want to do Table.SelectColumns(#Table,not {"col1","col2"})

i.e. to select all columns of the model apart from specific columns.

Thanks!

[AntonioM · Accepted solution]

I think you could combine Table.ColumnNames and List.RemoveItems

Something like

Table.SelectColumns(#Table, List.RemoveItems(Table.ColumnNames(#Table), {"Col1", "Col2}))