Keep Only Columns by Name Pattern in Power Query M

Keeps only the columns whose name contains a given text pattern, removing everything else.

Column OperationsIntermediatekeep columnspatterndynamic

Power Query M code

let
    Source = YourTable,
    ColumnsToKeep = List.Select(Table.ColumnNames(Source), each Text.Contains(_, "Sales")),
    Selected = Table.SelectColumns(Source, ColumnsToKeep)
in
    Selected

Notes

Change "Sales" to whatever substring identifies the columns you want to keep.

Requirements

A table whose wanted 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 Keep Only Columns by Name Pattern.