Currency.From
This function retrieves a currency value based on the input provided. If the input is null, the function will also return null. If the input is a number within the acceptable currency range, the funct...
Currency.From(value as any, optional culture as nullable text, optional roundingMode as nullable number) as nullable number
This function retrieves a currency value based on the input provided. If the input is null, the function will also return null. If the input is a number within the acceptable currency range, the function will round the fractional part to 4 decimal digits before returning it. Any other type of input will be converted to a number using Number.FromText before processing. The valid currency range is between -922,337,203,685,477.5808 and 922,337,203,685,477.5807. Different rounding modes can be specified using Number.Round. The default rounding mode is RoundingMode.ToEven. Additionally, a specific culture can be specified (e.g. "en-US") for formatting purposes.
Retrieve the currency value of "1.23455" by utilizing the Power Query function MCurrency.From. In this scenario, the output will be displayed as 1.2346, showing the rounded value. To obtain the currency value of "1.23455" with rounding mode set to down, specify the desired settings in the Power Query function MCurrency.From. This will result in an output of 1.2345, reflecting the rounded-down value.