Replace Nulls with Zero in All Number Columns in Power Query M

Fills null values with 0 across every numeric column in a table at once.

Data CleaningIntermediatenullzeronumbersbulkfill

Power Query M code

let
    Source = YourTable,
    NumberColumns = List.Select(Table.ColumnNames(Source), each Type.Is(Value.Type(Table.Column(Source, _)), type number)),
    Replaced = Table.ReplaceValue(Source, null, 0, Replacer.ReplaceValue, NumberColumns)
in
    Replaced

Notes

Detects numeric columns automatically, so it adapts if columns are added or removed.

Requirements

A table with one or more numeric columns.

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 Replace Nulls with Zero in All Number Columns.