The power function evaluates a base by raising it to the power of a given exponent.
Examples
The power function can be used to raise a number to the power of another number. For example, 23 would be written as:
power(2, 3)
Typically, the power function is used with a field reference or an expression.
For example:
power(${order_item.standard_deviation_profit},2)
Things to know
The power function can also be used to take the nth root of a number by using 1/n as the exponent. For example, the cube root (the 3rd root) of 7 would be:
power(7, 1/3)
For a square root (the 2nd root) just use the sqrt function.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-25 UTC."],[],[],null,["# power\n\nThe `power` function can be used in [custom filters](/looker/docs/2512/filtering-and-limiting#custom-filters) and [table calculations](/looker/docs/2512/table-calculations) to raise a number to the power of a given exponent.\n\nSyntax\n------\n\n**`power(base, exponent)`**\n\nThe `power` function evaluates a `base` by raising it to the power of a given `exponent`.\n\nExamples\n--------\n\nThe `power` function can be used to raise a number to the power of another number. For example, 2^3^ would be written as: \n\n power(2, 3)\n\nTypically, the `power` function is used with a field reference or an expression.\nFor example: \n\n power(${order_item.standard_deviation_profit}, 2)\n\nThings to know\n--------------\n\nThe `power` function can also be used to take the nth root of a number by using 1/n as the `exponent`. For example, the cube root (the 3rd root) of 7 would be: \n\n power(7, 1/3)\n\nFor a square root (the 2nd root) just use the `sqrt` function."]]
