Fabric Plan Community Logo
Sign in

PCT

The PCT function is used to perform percentage calculations by converting a numeric value into its percentage equivalent. It is commonly used in financial and business calculations to apply percentage-based increases, decreases, or adjustments to measures and values.

Syntax

PCT(value)

Arguments

  • value: The percentage value in numeric format.

Return value

Returns the percentage equivalent of the specified value.

Example

SALES + PCT(10)

In this example, the PCT function converts 10 into 10% and adds it to the SALES value. The formula returns the current sales value plus 10% of sales.

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.