Skip to content

MODLR

Main Navigation Documentation

Modelling Guides

Sidebar Navigation

Cube Functions

Conditional Functions

AND

IF

NOT

OR

SWITCH

XOR

Datasource Functions

SQLCOLUMN

SQLCOLUMNNAME

SQLROW

SQLVALUE

Date Functions

Construction & Parsing

DATE

DATEVALUE

TIME

TIMEVALUE

NOW

TODAY

Components

DAY

MONTH

YEAR

HOUR

MINUTE

SECOND

WEEKDAY

WEEKDAYEX

WEEKNUM

Arithmetic & Differences

DATEDIF

DAYS

EDATE

EOMONTH

MONTHDAYCOUNT

MONTHDAYS

MONTHWORKDAYS

NETWORKDAYS

SNETWORKDAYS

WORKDAY

Formatting

FORMATDATE

FORMATTIME

Dimension Functions

Element Lookup

ALIAS

ELEMENT

ELEMENTBYPOSITION

ELEMENTEXISTS

ELEMENTTYPE

MAPPEDELEMENT

OFFSET

Hierarchy & Parent-Child

CHILD

CHILDPOSITION

CHILDREN

DESCENDANTS

ELEMENTHASANCESTOR

HASCOMMONCHILDREN

HIERARCHYBYPOSITION

HIERARCHYHASMEMBER

ISLEAF

ISLEVELZERO

LEVELSBETWEEN

PARENT

Static Values & Properties

CONTAINSSTATICVALUES

CONTEXTDUMP

COUNTSTATICVALUES

HASSTATICVALUE

SUMSTATICVALUES

Counts & Indexes

CHILDCOUNT

CUBEDIMENSIONBYPOSITION

CUBEDIMENSIONCOUNT

HIERARCHYCOUNT

NTHCOUNT

PARENTCOUNT

POSITION

Financial Functions

Depreciation

DB

DDB

SLN

SYD

VDB

Interest & Loans

FV

IPMT

NPER

PMT

PPMT

PV

RATE

Returns (IRR)

CUBEIRR

CUBEXIRR

Tax

ATO_DV

ATO_PC

Modelling Functions

Consolidation

CONSOLIDATEAVERAGE

CONSOLIDATEAVERAGENOZEROS

CONSOLIDATEMAX

CONSOLIDATEMAXNOZEROS

CONSOLIDATEMEDIAN

CONSOLIDATEMEDIANNOZEROS

CONSOLIDATEMIN

CONSOLIDATEMINNOZEROS

CONSOLIDATESTANDARDDEVIATION

CONSOLIDATESTANDARDDEVIATIONNOZEROS

Descendant Values

FIRSTDESCENDANTVALUE

FIRSTPOPULATEDDESCENDANTVALUE

LASTDESCENDANTVALUE

LASTPOPULATEDDESCENDANTVALUE

Links & Mapping

LINK

LINKBY

LINKDIM

MAPPING

Data & Variables

FIELD

SEQUENCE

VARIABLE

Numeric Functions

Arithmetic & Aggregation

ARRAY

AVERAGE

AVERAGENOZEROS

MAX

MIN

MOD

Rounding & Sign

ABS

CEIL

FLOOR

INT

ROUND

Trigonometric

ACOS

ASIN

ATAN

COS

COSH

SECH

SIN

TAN

Logarithmic & Power

EXP

LOG

POW

POWER

SQRT

Statistical & Random

MEDIAN

MODE

RAND

RANDBETWEEN

STDDEV

Conversion & Formatting

NUMBER

NUMBERFORMAT

STRING

Search & Utility

CONTAINS

OCCURRENCES

Colour

COLORDARKEN

COLORHUESHIFT

COLORINVERT

COLORLERP

COLORLIGHTEN

String Functions

Manipulation

LEFT

MID

RIGHT

REPEAT

REPT

SPLIT

Search & Replace

LEN

REPLACE

SEARCH

SUBSTITUTE

Case & Trim

LOWER

PROPER

TOGGLESTRING

TRIM

TRIMLEFT

TRIMRIGHT

UPPER

Encoding

URLDECODE

URLENCODE

User Functions

USERCARDACCESS

USERELEMENTACCESS

USERHASGROUP

Are you an LLM? You can read better optimized documentation at /cube-functions/pow.md for this page in Markdown format

POW

See POWER.

Last updated:

Pager

Previous pageLOG

Next pagePOWER

POW ​

POW