ODD

The ODD function rounds a number up and returns the nearest higher odd integer. If the input number is already an odd number, it remains unchanged. The function accepts numeric values or node references as arguments and is useful in calculations where results must conform to odd-number requirements.

Syntax

ODD(value)

Arguments

  • value: The input number to round to the nearest higher odd integer.

Return value

Returns the nearest higher odd integer.

Example

ODD(Planned Units)

In this example, the ODD function is used to create the Odd Planned Units measure, which returns the values in the Planned Units measure rounded up to the nearest odd integer.

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.