DOLLARDE

How to Use the Power BI DAX function DOLLARDE

Understanding the DOLLARDE Function

The DOLLARDE function is a part of the Data Analysis Expressions (DAX) language, which is a formula language used in Power BI. The function allows you to convert a numeric value into a specific currency value.

The syntax of the DOLLARDE function is as follows:


DOLLARDE(decimal_number, fraction)


- decimal_number: This is a required field and represents the decimal number that needs to be converted into a currency.

- fraction: This is also a required field and represents the fraction of the currency that you want to use.

For example, if you want to convert a decimal number into a currency that has two decimal places, such as USD, you would use a fraction of 0.01.

Using DOLLARDE Function in Power BI

To use the DOLLARDE function in Power BI, follow the steps below:

1. Open the Power BI Desktop and create a new report.

2. Select the table or column that contains the decimal number that you want to convert into a currency.

3. Click on the "New Measure" button in the "Modeling" tab.

4. Enter the following DAX formula into the formula bar:


Currency Value = DOLLARDE(decimal_number, fraction)


5. Replace the "decimal_number" and "fraction" fields with the appropriate values.

6. Press "Enter" to create the new measure.

7. Drag and drop the new measure onto the report.

Examples of Using DOLLARDE Function in Power BI

Here are some examples of how you can use the DOLLARDE function in Power BI:

Example 1: Converting a Decimal Value to USD

Suppose you have a table that contains decimal values of sales revenue, and you want to convert these values into USD. Here's how you can use the DOLLARDE function to accomplish this:


Sales in USD = DOLLARDE(Sales, 0.01)


Example 2: Converting a Decimal Value to EUR

Suppose you have a table that contains decimal values of sales revenue, and you want to convert these values into EUR. Here's how you can use the DOLLARDE function to accomplish this:


Sales in EUR = DOLLARDE(Sales, 0.01)


The DOLLARDE function is a powerful tool that allows you to convert decimal values into a specific currency of your choice. By following the steps outlined in this article, you can easily use the DOLLARDE function in Power BI to convert your decimal values into the desired currency.

Power BI DAX Training Courses by G Com Solutions (0800 998 9248)

Upcoming Courses

Contact Us

    Subject

    Your Name (required)

    Company/Organisation

    Email (required)

    Telephone

    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)