Dax Function: DOLLARDE

Category: Financial Functions

The DOLLARDE function converts a dollar price expressed as a fractional value into a decimal value. This function is useful when working with prices that use fractional representation, such as in finance and investment markets.

Purpose

• The DOLLARDE function simplifies fractional pricing by converting it to decimal format for easier calculations.

• Primarily used in financial analysis for securities, such as bonds, that often use fractions to denote prices (e.g., 99 7/8 as 99.875).

Type of Calculations

• Converts prices expressed as mixed numbers (whole numbers and fractions) into their decimal equivalents.

• Handles fractional denominations accurately by considering the base of the fraction.

Practical Use Cases

• Bond Pricing: Convert bond prices from fractional quotes to decimal for financial modeling.

• Portfolio Valuation: Standardize pricing formats across securities for consistency in analysis.

• Market Data Analysis: Process historical or real-time market data that uses fractional price notation.

How Does DOLLARDE Dax Function Works

Concept

The DOLLARDE function splits the fractional dollar into two parts:

1. The integer portion (e.g., 99 in 99 7/8).

2. The fractional portion (e.g., 7/8 in 99 7/8).

It then computes the decimal equivalent:

​

For example:

• Input: 99.875, Fraction: 8

• Calculation: 99 + 7/8 = 99.875

What Does It Return?

• Returns the decimal equivalent of the fractional dollar price.

• Result is a scalar decimal value.

When Should We Use It?

• Convert Financial Data: When financial data uses fractional dollar notation for prices.

• Bond Pricing Models: Standardize prices to decimal format for complex calculations.

• Data Cleaning: Simplify datasets containing mixed pricing formats.

Examples

Basic Usage :

Convert 99 7/8 to a decimal price.

Result: 99.875

Fractional Input

Convert 105 3/16 to a decimal price with a fraction denominator of 16.

Result: 105.1875

Column Usage

Apply DOLLARDE to a table of fractional prices.

This converts all fractional dollar prices in the FractionalDollar column using the respective denominators in the Fraction column.

Tips and Tricks

• Ensure the fractional dollar input follows the format Integer Part + Denominat/Numerator​.

• Verify that the fraction parameter matches the actual fractional denomination (e.g., 8 for eighths, 16 for sixteenths).

• If the fraction parameter is not consistent with the input format, results will be incorrect.

• Fractional values must be positive; negative values may cause unexpected results.

Performance Impact of DOLLARDE DAX Function:

• Efficient: Handles large datasets with ease, as it operates on scalar values.

• Consistency: Ensure proper data preprocessing for fractional inputs to maximize performance in large-scale models.

Related Functions You Might Need

Want to Learn More?
For more information, check out the official Microsoft documentation for DOLLARDE You can also experiment with this function in your Power BI reports to explore its capabilities.

Unlock the full capabilities of Power BI and elevate your data insights with our specialized consulting services. Whether you need guidance on advanced DAX functions like those highlighted here, support in designing interactive dashboards, or expertise in optimizing data models for enhanced performance, our experienced Power BI consultants are equipped to deliver customized solutions for your business. Explore our Power BI Consulting Services page to discover how we can help your organization make smarter, data-driven decisions.