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


Returns a currency value from the given value. If the given value is null, Currency.From returns null. If the given value is number within the range of currency, fractional part of the value is rounded to 4 decimal digits and returned. If the given value is of any other type, see Number.FromText for converting it to number value, then the previous statement about converting number value to currency value applies. Valid range for currency is -922,337,203,685,477.5808 to 922,337,203,685,477.5807. See Number.Round for the available rounding modes. The default is RoundingMode.ToEven. An optional culture may also be provided (for example, “en-US”).

Reference Data

Power Query M Functions / Number Functions / Currency.From