# ROUNDDOWN

## Syntax of ROUNDDOWN Function

The syntax of the ROUNDDOWN function in Power BI DAX is as follows:

ROUNDDOWN(❰number❱, ❰num_digits❱)

``` 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: ```

=ROUNDDOWN(Sales[Sales], 2)

``` 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) Power BI DAX Intensive Training Course £1,260.00 – £31,860.00 Select optionsContinue Loading Done Power BI DAX Introduction £474.00 – £11,700.00 Select optionsContinue Loading Done Power BI DAX Intermediate £474.00 – £11,700.00 Select optionsContinue Loading Done Power BI DAX Advanced £474.00 – £11,700.00 Select optionsContinue Loading Done Upcoming Courses 16-18 September 202411-13 November 2024 Contact Us Subject Your Name (required) Company/Organisation Email (required) Telephone Training Course(s) Power BI Intensive TrainingPower BI introduction Power BI IntermediatePower BI AdvancedDAXPower Query MPower BI CertificationPower BI AdministrationPower PlatformPower AutomatePower AppsOTHER Your Message Upload Example Document(s) (Zip multiple files) ```
``` ```
``` ```
``` ```
``` ```
``` ```