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.


DOLLARFR(<decimal_dollar>, <fraction>)


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.


  • 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.


The following DAX query:

  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.