Fabric Plan Community Logo
Sign in

ABS

The ABS function returns the absolute value of a number, which represents the number’s magnitude without considering its sign. Negative values are converted to positive values, while positive values and zero remain unchanged. This function is commonly used in calculations where only the magnitude of a value is required.

Syntax

ABS(value)

Arguments

  • value: The number for which to return the absolute value.

Return value

Returns the absolute value of the specified number.

Example

ABS(Variance%)

In the example below, the Absolute Variance measure is created using the ABS function to display the absolute values (without a sign) of the Variance% measure.

Excel equivalent

ABS

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.