DOLLARDE

DOLLARDE is a DAX function that converts a dollar price expressed as an integer and fraction into a decimal number.

Syntax

DOLLARDE(
   Fractional_dollar,
   Fraction
)

Argument	Properties	Description
Fractional_dollar		A number expressed as an integer part and a fraction part, separated by a decimal symbol.
Fraction		The integer to use in the denominator of the fraction.

Return Values

The decimal value of fractional_dollar.

Remarks

• The fraction part of the value is divided by an integer that you specify. For example, if you want your price to be expressed to a precision of 1/16 of a dollar, you divide the fraction part by 16. In this case, 1.02 represents $1.125 ($1 + 2/16 = $1.125).

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

EVALUATE
{
  DOLLARDE(1.02, 16)
}

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

Related functions

Other functions related to DOLLARDE are:

• DOLLARFR

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/dollarde-function-dax