Редагувати

Поділитися через

DOLLARFR

  • Стаття

Applies to: Calculated column Calculated table Measure Visual calculation

Converts a dollar price expressed as a decimal number into a dollar price expressed as an integer part and a fraction part, such as 1.02. Fractional dollar numbers are sometimes used for security prices.

Syntax

DOLLARFR(<decimal_dollar>, <fraction>)

Parameters

Term Definition
decimal_dollar A decimal number.
fraction The integer to use in the denominator of the fraction.

Return Value

The fractional value of decimal_dollar, expressed as an integer part and a fraction part.

Remarks

  • fraction is rounded to the nearest integer.

  • An error is returned if:

    • fraction < 1.

  • This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Example

The following DAX query:

EVALUATE
{
  DOLLARFR(1.125, 16)
}

Returns 1.02, read as 1 and 2/16, which is the corresponding fraction price of the original decimal price, 1.125. Since the fraction value is 16, the price has a precision of 1/16 of a dollar.