Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Returns e raised to the power of a given number. The constant e equals 2.71828182845904, the base of the natural logarithm.
EXP is the inverse of LN, which is the natural logarithm of the given number.
To calculate powers of bases other than e, use the exponentiation operator (^). For more information, see DAX Operator Reference for Power Pivot.
The following formula calculates e raised to the power of the number contained in the column, [Power].