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

DOLLARFR ( <Decimal_dollar>, <Fraction> )
Parameter Attributes Description
Decimal_dollar

A decimal number.

Fraction

The integer to use in the denominator of the fraction.

Return values

Scalar A single decimal value.

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.

» 1 related function

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

2018-2026 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us   » Privacy Policy & Cookies

Context Transition

This function performs a Context Transition if called in a Row Context. Click to read more.

Row Context

This expression is executed in a Row Context. Click to read more.

Passed by Expression

This parameter is passed by expression and can be evaluated multiple times in different evaluation contexts.

Iterator

Not recommended

The use of this function is not recommended. See Remarks and Related functions for alternatives.

Not recommended

The use of this parameter is not recommended.

Deprecated

This function is deprecated. Jump to the Alternatives section to see the function to use.

Volatile

A volatile function may return a different result every time you call it, even if you provide the same arguments. Click to read more.

Deprecated

This parameter is deprecated and its use is not recommended.

DirectQuery compatibility

Limitations are placed on DAX expressions allowed in measures and calculated columns.
The state below shows the DirectQuery compatibility of the DAX function.

Contribute

Want to improve the content of DOLLARFR? Did you find any issue?
Please, report it us! All submissions will be evaluated for possible updates of the content.