Where:

- `❰number❱` is the value that you want to round down.

- `❰num_digits❱` is the number of digits to which you want to round down.

Example

Suppose you have a table named 'Sales' with the following data:

| Product | Sales |

|---------|-------|

| A | 123.45|

| B | 567.89|

| C | 101.11|

To round down the sales figure to 2 decimal places, you can use the following DAX formula:

This formula will round down the sales figures in the 'Sales' column of the 'Sales' table to 2 decimal places.

Usage of ROUNDDOWN Function

The ROUNDDOWN function is useful in various scenarios. Some of the common use cases are as follows:

Financial Analysis

In financial analysis, it is often required to round down the financial figures to a specific number of decimal places. For example, the stock prices are usually rounded down to 2 decimal places. The ROUNDDOWN function can be used to achieve this.

Data Analysis

In data analysis, the ROUNDDOWN function can be used to reduce the complexity of the data. For example, if you have a large dataset with many decimal places, you can use the ROUNDDOWN function to reduce the number of decimal places and make the data more manageable.

Formatting

The ROUNDDOWN function can also be useful for formatting purposes. For example, if you want to display the sales figures in a report with 2 decimal places, you can use the ROUNDDOWN function to format the data.

The ROUNDDOWN function in Power BI DAX is a useful function that can be used to round down a given number to a specified number of decimal places. It is useful in financial analysis, data analysis, and formatting. The syntax of the ROUNDDOWN function is straightforward, and it can be used with ease. In this article, we have discussed the usage of the ROUNDDOWN function with examples.

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

Upcoming Courses

Contact Us