Fabric Plan Community Logo
Sign in

ROUNDUP

The ROUNDUP function rounds a number up, away from zero, to a specified number of decimal places. It always increases the value regardless of the following digits and is useful in scenarios where higher estimates, pricing adjustments, or safety margins are required.

Syntax

ROUNDUP(value, significance)

Arguments

  • value: The number to round.
  • significance (Optional): The number of decimal places to round to.

Return value

Returns the number rounded up, away from zero, to the specified number of decimal places.

Example

ROUNDUP(Actuals, 2)

In this example, the Rounded Sales measure is created using the ROUNDUP function, which rounds the values in Total Sales up, away from zero, to two decimal places.

Excel equivalent

ROUNDUP

Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
CERTIFIED BY
Fabric Planning is certified by IBCS
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.