Remove Columns by Name Pattern in Power Query M

Removes every column whose name contains a given text pattern, instead of listing columns by exact name.

Column OperationsIntermediateremove columnspatterndynamic

Power Query M code

let
    Source = YourTable,
    ColumnsToRemove = List.Select(Table.ColumnNames(Source), each Text.Contains(_, "_temp")),
    Removed = Table.RemoveColumns(Source, ColumnsToRemove)
in
    Removed

Notes

Change "_temp" to whatever substring identifies the columns you want dropped.

Requirements

A table whose disposable columns share a common naming pattern.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Remove Columns by Name Pattern.