POWER

Overview

Description

Returns the power of the values, using the first input as the base and the second as the exponent. Both inputs can be numbers as well as nodes.

Use when you need to raise a node or numeric value to a fixed or row-wise exponent.

Syntax

POWER('Node1' | value, 'Node2' | value)

Parameters

Base (Node1 | value): The value that will be multiplied by itself, specified using the node name in single quotes (e.g. 'Profit')
Exponent (Node2 | value): The number of times the base will be multiplied by itself. Can also be a number or a fraction, for example 1/3 to calculate a third root.

Example

Raising one node to the power of another

This example shows POWER applied row-wise using node A as the base and node B as the exponent. Here the exponent is constant at 2, so the result squares each base value.

Input node: Base

Year	Value
2025	2
2026	3
2027	4.5

Input node: Exponent

Year	Value
2025	2
2026	2
2027	2

Formula: POWER('Base', 'Exponent')

Year	→ POWER Result
2025	4
2026	9
2027	20.25

Related Functions

Function	When to use instead
SQRT	When you only need the square root of a single input instead of a general exponentiation.
EXP	When you need exponentiation with the fixed base e instead of a custom base and exponent.