Convert Parentheses to Negative Numbers in Power Query M

Converts accounting-style values shown in parentheses, like (100), into a proper negative number.

Data TypesIntermediatenegativeparenthesesaccountingnumber

Power Query M code

let
    Source = YourTable,
    Converted = Table.TransformColumns(Source, {{"ColumnName", each
        if Text.StartsWith(Text.Trim(_), "(") then
            -Number.From(Text.Select(_, {"0".."9", "."}))
        else
            Number.From(Text.Select(_, {"0".."9", "."})),
        type number}})
in
    Converted

Notes

Run this before general currency cleanup if a column mixes plain numbers with parenthesized negatives.

Requirements

A text column where negative values are wrapped in parentheses.

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 Convert Parentheses to Negative Numbers.