Try / Otherwise Error Handling in Power Query M

Wraps a calculation in try...otherwise so the query keeps running with a fallback value instead of failing on the first error.

Error HandlingBeginnertryotherwiseerror handlingfallback

Power Query M code

let
    Source = YourTable,
    AddedSafeColumn = Table.AddColumn(Source, "SafeResult", each try [Numerator] / [Denominator] otherwise 0, type number)
in
    AddedSafeColumn

Notes

Replace the expression after try with your own calculation, and the value after otherwise with whatever fallback makes sense (0, null, "N/A").

Requirements

A table where a calculation may fail for some rows (e.g. division by zero).

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 Try / Otherwise Error Handling.