Convert Percent Text to Decimal in Power Query M

Converts a text value like 45% into its decimal equivalent (0.45) as a proper number.

Data TypesBeginnerpercentdecimalnumberconvert

Power Query M code

let
    Source = YourTable,
    Converted = Table.TransformColumns(Source, {{"ColumnName", each Number.From(Text.Replace(_, "%", "")) / 100, type number}})
in
    Converted

Notes

If the column is already typed as text with a trailing % sign, this both strips the symbol and rescales to a decimal fraction.

Requirements

A text column containing percentage values with a % sign.

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 Percent Text to Decimal.