Decimal.From

This function retrieves a Decimal number value based on the input provided. If the input is null, the function will return null. If the input is a number within the appropriate range for Decimal, the ...

Syntax

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

About

This function retrieves a Decimal number value based on the input provided. If the input is null, the function will return null. If the input is a number within the appropriate range for Decimal, the value will be returned. Otherwise, an error will be generated. If the input is of a different type, it will be converted to a number using the Number.FromText function. Additionally, an optional culture parameter can be included (e.g. "en-US") for localization purposes.

Explanation

Retrieve the Decimal numerical value of "4.5" using Power Query function MDecimal.From("4.5"). The output will be 4.5.