Daily DAX : Day 367 ROUND

🔢Power BI DAX: ROUND Function

Syntax

ROUND(<number>, <num_digits>)

What it does:

ROUND rounds a number to a specified number of decimal places.

Parameter	Description	Example
<number>	The number to round	12.346
<num_digits>	Decimal places (0 = whole number)	2

Examples:

ROUND(12.346, 2) → 12.35

ROUND(12.346, 0) → 12

ROUND(12.346, 1) → 12.3

🎯 Common Use Cases

1. Financial Reports: Round currency to 2 decimals
   Total Sales = ROUND(SUM(Sales[Amount]), 2)
2. KPIs: Show whole numbers
   Customer Count = ROUND(COUNT(Customers[ID]), 0)
3. Percentages: Clean display
   Growth % = ROUND([Sales Growth] * 100, 1)
4. Average Scores: Round to 1 decimal
   Avg Rating = ROUND(AVERAGE(Reviews[Score]), 1)

💡 Quick Tip:

Positive num_digits = decimals after point
Negative num_digits = round to thousands, millions, etc.
ROUND(1234, -2) → 1200