Skip to content

Automatic translation — the Portuguese version is the reference. View in Portuguese

POTENCIA

On this page (10)

Base raised to the exponent.

FieldValue
CategoryMath
TypeScalar (operates value by value)
Arity2 arguments (fixed)
Compiles to SQL (calculated column)Yes
VersionFormula engine v3.

Aliases#

Canonical name: POTENCIA. Accepted aliases (case-insensitive): power, pow.

Syntax#

code
POTENCIA(expr; arg2)

All arguments are expressions.

Returns#

Number.

Null handling#

Text that is not a number, or a blank value in a calculation, becomes a friendly error (pt-BR) — never a silent zero.

Evaluation context#

Scalar — evaluated on the result of the arguments (in calculated columns, it runs row by row).

Differences from DAX#

  • DAX equivalent: POWER
  • Compatibility: Compatible with DAX
  • Note: Base raised to the exponent, same as POWER.

Examples#

code
POTENCIA(2; 10)

Example with values#

Input: base 2, exponent 10.

code
POTENCIA(2; 10)  →  1024

Expected result: 1024

Business example#

Normalize financial numbers — round prices, remove the sign from a deviation, compute powers/roots.

Common errors#

Typos in a column name, an incompatible type, or an invalid argument become a friendly message (pt-BR) — the engine never silently returns a wrong number.


← Back to the formula index

Related links