Dax Function: DOLLARFR

Category: Financial Functions

The DOLLARFR function converts a dollar price expressed as a decimal value into a fractional value. This function is commonly used in financial markets where prices are quoted in fractions (e.g., eighths, sixteenths).

Purpose

• The DOLLARFR function standardizes decimal dollar prices into fractional notation, making them compatible with traditional market practices.

• It simplifies the process of converting prices for financial analysis, particularly for bonds and other securities.

Type of Calculations

• Converts a decimal dollar price into its fractional equivalent based on a specified fraction denominator.

• Ensures that financial data aligns with traditional formats used in market analysis.

Practical Use Cases

• Bond Pricing: Transform decimal prices into fractional quotes (e.g., 99.875 → 99 7/8).

• Market Data Formatting: Prepare price data for integration with legacy financial systems.

• Financial Reporting: Align decimal data with industry-standard fractional pricing conventions.

How Does DOLLARFR Dax Function Works

The DOLLARFR function converts a decimal dollar into a fractional dollar using the following formula:

​

For example:

• Input: 99.875, Fraction: 8

• Calculation:  (fractional representation: 99 7/8).

What Does It Return?

• Returns the fractional equivalent of the decimal dollar price as a scalar value.

• Result is formatted as a mixed number (integer part + fractional part).

When Should We Use It?

• Convert Decimal to Fractional Data: When working with financial datasets that require fractional notation.

• Standardize Price Formats: Convert decimal dollar prices to match traditional financial quoting systems.

• Preprocessing for Reports: Format prices for historical analysis or legacy system compatibility.

Examples

Basic Usage :

Convert a decimal dollar price of 99.875 to a fractional price with a denominator of 8.

Result: 99.7 (interpreted as 99 7/8).

Different Denominator

Convert 105.1875 (decimal) into a fractional price with a denominator of 16.

Result: 105.3 (interpreted as 105 3/16).

Column Usage

Apply DOLLARFR to a column of decimal prices.

This converts each decimal dollar price in the DecimalDollar column into a fractional format using the respective denominators in the Fraction column.

Tips and Tricks

• Ensure the fraction parameter matches the actual fractional denominator used in the dataset (e.g., 8 for eighths, 16 for sixteenths).

• Use alongside DOLLARDE to toggle between decimal and fractional formats seamlessly.

• Fractional denominators must be integers greater than 0. Negative or zero values will cause errors.

• Data formatting: Properly interpret the fractional output (e.g., 99.7 as 99 7/8).

Performance Impact of DOLLARFR DAX Function:

• Efficient: Works seamlessly with scalar values and large datasets.

• Data Quality: Ensure proper data validation before applying the function for consistent results.

Related Functions You Might Need

Want to Learn More?
For more information, check out the official Microsoft documentation for DOLLARFR 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.