🔄 Power Query examples

Power Query M examples and workflows

Browse practical Power Query examples for cleaning, shaping, combining and transforming data in Excel or Power BI. Each page includes M code, UI steps, mistakes to avoid and copy-ready patterns.

50 Power Query pages250 practical examplesCopy-ready M code

💡 Ideas for You

Learning resources for Power Query, data cleaning and repeatable reporting.

4 useful links

📚Step-by-step books
Start with beginner-friendly step-by-step books and learning resources from Create & Learn.
🔄Power Query guide
Helpful references for cleaning, merging, appending and reshaping data.
🧹Data cleaning books
Resources for better data prep, transformations and workflow design.
📊Excel reporting
Books for reporting pipelines, dashboards and spreadsheet analysis.

Some links in this section may be affiliate links. Choose only what is useful for your own work.

Browse Power Query examples

Use the filters to find cleaning, transformation, import, function, error-handling and refresh examples.

Remove columns examples

Remove columns examples.

Rename columns examples

Rename columns examples.

Change data types examples

Change data types examples.

Split columns examples

Split columns examples.

Merge columns examples

Merge columns examples.

Replace values examples

Replace values examples.

Fill down examples

Fill down examples.

Remove duplicates examples

Remove duplicates examples.

Filter rows examples

Filter rows examples.

Sort rows examples

Sort rows examples.

Group by examples

Group by examples.

Combine & Import

Merge queries examples

Merge queries examples.

Combine & Import

Append queries examples

Append queries examples.

Transform Columns

Unpivot columns examples

Unpivot columns examples.

Transform Columns

Pivot columns examples

Pivot columns examples.

Transform Columns

Extract text examples

Extract text examples.

Transform Columns

Clean text examples

Clean text examples.

Transform Columns

Parse dates examples

Parse dates examples.

Transform Columns

Conditional column examples

Conditional column examples.

Transform Columns

Custom column examples

Custom column examples.

Table.SelectRows examples

Table.SelectRows examples.

Table.AddColumn examples

Table.AddColumn examples.

Table.TransformColumnTypes examples

Table.TransformColumnTypes examples.

Table.RenameColumns examples

Table.RenameColumns examples.

Table.RemoveColumns examples

Table.RemoveColumns examples.

Table.Group examples

Table.Group examples.

Combine & Import

Table.NestedJoin examples

Table.NestedJoin examples.

Combine & Import

Table.Combine examples

Table.Combine examples.

Transform Columns

Table.UnpivotOtherColumns examples

Table.UnpivotOtherColumns examples.

Text.Contains examples

Text.Contains examples.

Text.Start Text.End examples

Text.Start Text.End examples.

Text.BetweenDelimiters examples

Text.BetweenDelimiters examples.

Date.From examples

Date.From examples.

Number.From examples

Number.From examples.

List.Sum examples

List.Sum examples.

Combine & Import

Combine files from folder examples

Combine files from folder examples.

Combine & Import

Import CSV examples

Import CSV examples.

Combine & Import

Import Excel files examples

Import Excel files examples.

Combine & Import

Web data import examples

Web data import examples.

Parameters & Functions

Parameter examples

Parameter examples.

Parameters & Functions

Function examples

Function examples.

Errors & Data Quality

Error handling examples

Error handling examples.

Errors & Data Quality

Replace errors examples

Replace errors examples.

Transform Columns

Remove blank rows examples

Remove blank rows examples.

Transform Columns

Trim clean text examples

Trim clean text examples.

Dates & Calendars

Create calendar table examples

Create calendar table examples.

Dates & Calendars

Fiscal calendar examples

Fiscal calendar examples.

Performance & Refresh

Slow query performance tips

Slow query performance tips examples.

Performance & Refresh

Refresh workflow examples

Refresh workflow examples.

Performance & Refresh

Query folding examples

Query folding examples.