← Back to Number functions

Single.From

The function Single.From returns a numeric value from the input provided. If the input is null, the function returns null. If the input is a number within the acceptable range for a Single value, that...

Syntax

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

About

The function Single.From returns a numeric value from the input provided. If the input is null, the function returns null. If the input is a number within the acceptable range for a Single value, that same number is returned. Otherwise, an error is returned. If the input is of a different data type, it will be converted to a number using the Number.FromText function. Additionally, users have the option to specify a culture (e.g. "en-US").

Explanation

Retrieve the numerical value of "1.5" using Power Query MSingle.From function. Output will be 1.5.