Percentage.From

This function calculates a percentage based on the input value. If the input value is empty, the function will return an empty value. If the input value is a text with a percentage symbol at the end, ...

Syntax

Percentage.From(value as any, optional culture as nullable text) as nullable number

About

This function calculates a percentage based on the input value. If the input value is empty, the function will return an empty value. If the input value is a text with a percentage symbol at the end, the function will convert it to a decimal number. Otherwise, the input value will be converted to a number using the Number.From function. You can also specify an optional culture (e.g. "en-US") for localization purposes.

Explanation

Obtain the numerical value equivalent to "12.3%" using the Power Query MPercentage function. The output will be 0.123.