Convert Currency Text to Number ($1,200.50) in Power Query M

Notes

This removes everything except digits and the decimal point; use Convert Parentheses to Negative Numbers first if negatives are shown as ($100).

Requirements

• A text column containing currency-formatted values.

How to use this snippet

1. 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).
2. Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
3. Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

• Convert Parentheses to Negative NumbersConverts accounting-style values shown in parentheses, like (100), into a proper negative number.
• Convert Percent Text to DecimalConverts a text value like 45% into its decimal equivalent (0.45) as a proper number.
• Format a Number as Currency TextTurns a numeric column into a formatted currency string, such as $1,234.50.
• Convert a Text Column to NumberConverts a text column containing numeric values into a proper Number type.
• Convert a Column to Whole Number SafelyConverts a column to Int64, replacing any value that fails to convert with null instead of erroring the whole query.
• Convert a Text Column to DateConverts a text column containing dates into a proper Date type, using an explicit locale to avoid misreads.

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 Currency Text to Number ($1,200.50).