DOLLARDE
Applies to:
Calculated column
Calculated table
Measure
Visual calculation
Converts a dollar price expressed as an integer part and a fraction part, such as 1.02, into a dollar price expressed as a decimal number. Fractional dollar numbers are sometimes used for security prices.
Syntax
DOLLARDE(<fractional_dollar>, <fraction>)
Parameters
Term | Definition |
---|---|
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 Value
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.
Example
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.
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru