Power Fx function
Round — Power Fx function reference
Round to N decimals.
Syntax
powerfx
Round( Number, NumDecimalPlaces )
Examples
powerfx
Round(12.345, 1)
→ 12.3
powerfx
Round(Value(txtAmount.Text) * (1 + taxRate), 2)
powerfx
Round(Average(Reviews, Rating), 1)
Common mistakes & gotchas
- Round uses "round half away from zero", e.g. Round(2.5, 0) = 3 and Round(-2.5, 0) = -3, which differs from banker's rounding used elsewhere.
- A negative NumDecimalPlaces rounds to the left of the decimal point, e.g. Round(1250, -2) = 1300, a quick way to round to the nearest hundred.
Related Power Fx functions
From Math & aggregation