Rounding a Number to the Next Multiple of 10

Formula

In the context of DAX (Data Analysis Expressions), which is commonly used in Power BI and other Microsoft data tools, the formula to round a number to the next multiple of 10 is as follows:

NextMultipleOf10 = CEILING(Number, 10)

Explanation

• Function: The CEILING function is used to round a number up to the nearest specified multiple.
• Arguments:
  • Number: This represents the numeric value that you wish to round. Replace Number with the actual number or a reference to a column containing numeric values.
  • 10: This specifies the multiple to which you want to round. In this case, it is 10.
• Behavior: If the provided number is already a multiple of 10, the function will return that number. Otherwise, it will return the next highest multiple of 10.

Practical Example

Suppose we have a column named SalesAmount in a data table, and we want to create a new column that contains the value of SalesAmount rounded to the next multiple of 10.

DAX Implementation

RoundedSalesAmount = CEILING(Sales[SalesAmount], 10)

Explanation of Example

1. Sales: This is the name of the table that contains the column SalesAmount.
2. RoundedSalesAmount: This is the name of the new calculated column.
3. By using the CEILING function, any value in the SalesAmount will be rounded to the next multiple of 10:
   • For example, if SalesAmount is 23, RoundedSalesAmount would return 30.
   • If SalesAmount is 40, RoundedSalesAmount would return 40.

This approach provides a straightforward method to ensure that numerical values conform to specified rounding requirements, facilitating consistency in data reporting and analysis.