Dax Function: Math and Trigonometric Functions
Category: Math and Trigonometric functions
Math and Trigonometric (Trig) functions in Power BI are used to perform a variety of mathematical and geometric calculations within Data Analysis Expressions (DAX). These functions enable users to manipulate numerical data, perform arithmetic operations, and apply trigonometric formulas to solve complex analytical problems.
Purpose of the Function
The Math and Trig functions are essential tools in Power BI for handling numerical computations. They allow users to perform basic operations such as addition, subtraction, and rounding, as well as more advanced calculations like logarithms, exponents, and trigonometric transformations. These functions are invaluable for creating calculated columns, measures, and transforming raw data into actionable insights.
| Function | Description |
|---|---|
| ABS | Calculates the absolute value of a number. |
| ACOS | Computes the arccosine (inverse cosine) of a given value. |
| ACOSH | Returns the inverse hyperbolic cosine of a number. |
| ACOT | Provides the arccotangent (inverse cotangent) of a number. |
| ACOTH | Computes the inverse hyperbolic cotangent of a number. |
| ASIN | Determines the arcsine (inverse sine) of a value. |
| ASINH | Calculates the inverse hyperbolic sine of a number. |
| ATAN | Returns the arctangent (inverse tangent) of a value. |
| ATANH | Provides the inverse hyperbolic tangent of a number. |
| CEILING | Rounds a value up to the nearest integer or specified multiple. |
| CONVERT | Converts an expression from one data type to another. |
| COS | Computes the cosine of a specified angle. |
| COSH | Calculates the hyperbolic cosine of a value. |
| COT | Returns the cotangent of an angle in radians. |
| COTH | Determines the hyperbolic cotangent of an angle. |
| CURRENCY | Converts a value into the currency data type. |
| DEGREES | Transforms radians into degrees. |
| DIVIDE | Performs division and provides an alternate value or BLANK() if dividing by zero. |
| EVEN | Rounds a number up to the nearest even integer. |
| EXP | Calculates the value of e raised to the power of a given number. |
| FACT | Computes the factorial of a number (e.g., 1 × 2 × 3 × … up to the given number). |
| FLOOR | Rounds a value down to the nearest multiple or towards zero. |
| GCD | Determines the greatest common divisor of two or more integers. |
| INT | Rounds a value down to the nearest whole number. |
| ISO.CEILING | Rounds a number up to the nearest integer or specified multiple, in line with ISO standards. |
| LCM | Computes the least common multiple of integers. |
| LN | Returns the natural logarithm of a value. |
| LOG | Computes the logarithm of a number for a specified base. |
| LOG10 | Calculates the base-10 logarithm of a number. |
| MOD | Returns the remainder when one number is divided by another. |
| MROUND | Rounds a value to the nearest multiple you specify. |
| ODD | Rounds a number up to the nearest odd integer. |
| PI | Provides the value of Pi (3.14159265358979) accurate to 15 decimal places. |
| POWER | Returns a number raised to a specified power. |
| QUOTIENT | Performs division and returns only the integer portion of the result. |
| RADIANS | Converts degrees into radians. |
| RAND | Generates a random number between 0 (inclusive) and 1 (exclusive). |
| RANDBETWEEN | Produces a random value within a defined range. |
| ROUND | Rounds a value to the specified number of decimal places. |
| ROUNDDOWN | Rounds a number down towards zero. |
| ROUNDUP | Rounds a number up away from zero. |
| SIGN | Identifies the sign of a number (1 for positive, -1 for negative, or 0 for zero). |
| SIN | Computes the sine of a given angle. |
| SINH | Determines the hyperbolic sine of a value. |
| SQRT | Returns the square root of a number. |
| SQRTPI | Calculates the square root of a number multiplied by Pi. |
| TAN | Computes the tangent of a specified angle. |
| TANH | Determines the hyperbolic tangent of a number. |
| TRUNC | Truncates a number by removing its fractional part, leaving only the integer portion. |
Maximize the potential of Power BI and enhance your data insights with our expert consulting services. Whether you’re looking for assistance with advanced DAX functions, help designing interactive dashboards, or support in optimizing your data models for better performance, our skilled Power BI consultants are ready to provide tailored solutions for your business. Visit our Power BI consultancy page to learn more about how we can empower your organization to make more informed, data-driven decisions.
Math and Trig functions in Power BI are DAX functions that help perform numerical and geometric calculations, such as rounding, trigonometry, and logarithmic operations.
The ROUND function allows you to round numbers to a specified number of decimal places. Syntax: ROUND(<number>, <num_digits>).
CEILING rounds a number up to the nearest multiple, while FLOOR rounds it down to the nearest multiple.
By default, trigonometric functions like SIN and COS work with radians. Use the RADIANS function to convert degrees to radians.
The MOD function returns the remainder of a division operation. It is useful for cyclical patterns or repetitive calculations.
Established in 2020, Lets Viz Technologies provides a full range of high-quality data analysis and data visualization services. We are also an authorized Zoho Partner.
Sitelinks
