DOLLARFR DAX Function (Financial)
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 securities prices.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Decimal_dollar |
A decimal number. |
|
| Fraction |
The integer to use in the denominator of the fraction. |
Return values
The price as a fractional number. The integer part is the whole dollars, and the decimal digits are the numerator of the fraction.
Remarks
DOLLARFR writes the fraction part of Decimal_dollar as a numerator over Fraction, and shows that numerator as the decimal digits of the result. For example, DOLLARFR ( 1.125, 16 ) returns 1.02, which means 1 and 2/16.
The numerator uses as many decimal digits as there are digits in Fraction. With a Fraction of 32, DOLLARFR ( 1.3125, 32 ) returns 1.1, which means 1 and 10/32: the result is a number, so the trailing zero of 1.10 is not shown. Always read the result together with Fraction.
The numerator is not rounded. If the fraction part is not a multiple of 1/Fraction, the numerator has more decimal digits. For example, DOLLARFR ( 1.1, 16 ) returns 1.016, which means 1 and 1.6/16.
Fraction is rounded to the nearest integer. DOLLARFR returns an error if the rounded Fraction is less than 1, or if Fraction is BLANK. A negative Decimal_dollar returns a negative result. A BLANK Decimal_dollar returns BLANK.
DOLLARDE does the opposite conversion.
This function is not supported in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Examples
-- DOLLARDE converts a fractional price into a decimal price.
-- DOLLARFR converts the decimal price back into a fractional price.
-- The decimal digits of a fractional price are the numerator,
-- Fraction is the denominator: 1.02 with Fraction 16 is 1 and 2/16.
EVALUATE
ADDCOLUMNS (
{
( 1.02, 16 ),
( 99.08, 16 ),
( 101.1, 32 ),
( 101.31, 32 )
},
"DOLLARDE", DOLLARDE ( [Value1], [Value2] ),
"DOLLARFR", DOLLARFR ( DOLLARDE ( [Value1], [Value2] ), [Value2] )
)
| Value1 | Value2 | DOLLARDE | DOLLARFR |
|---|---|---|---|
| 1.02 | 16 | 1.125 | 1.02 |
| 99.08 | 16 | 99.49999999999999 | 99.08 |
| 101.1 | 32 | 101.31249999999999 | 101.1 |
| 101.31 | 32 | 101.96875 | 101.31 |
Related functions
Other related functions are:
Last update: Nov 13, 2026 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://learn.microsoft.com/en-us/dax/dollarfr-function-dax