Introduction
In this article you will learn about one of the most commonly used DAX functions in Power BI, the mathematical functions. These are very similar to the functions used in Excel sheets.
I have already explained some of the categories of DAX functions in a previous article.
Functions and Description
CEILING
Rounds a number up, to the nearest integer or to the nearest unit of the significance.
Syntax - CEILING (Number, Significance)
Number - A number you want to round or a column that contains a number.
Significance - The multiple of significance to which you want to round. For example, to round to the nearest integer, type 1.
Ex.
COMBIN
Returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups for a given number of items.
Syntax - COMBIN (Number, Number_chosen)
Number - A number of items
Number_chosen - The number of items in each combination.
Ex.
COMBINA
Returns the number of combinations (with repetition) for a given number of items.
Syntax - COMBINA(Number, Number_Chosen)
Number - Number must be greater than or equal to zero, and greater than or equal to Number_chosen. Non-integer values are truncated.
Number_Chosen - Must be greater than or equal to 0. Non-integer values are truncated.
Ex.
CONVERT
Converts an expression to the specified data type.
Syntax - CONVERT (Expression, DataType)
Expression - Any valid expression
DataType - It can be any data type like INTEGER, DOUBLE, STRING.
Ex.
CURRENCY
Returns the value as a currency data type.
Syntax- CURRENCY(Value)
Value- Any DAX expression that returns a single scalar value.
Ex.
DIVIDE
Safely divide a function with the ability to handle divide by zero case.
Syntax - DIVIDE(Numerator, Denominator, [AlternateResult])
Numerator - The dividend or number to divide.
Denominator - The divisor or number to divide by.
[AlternateResult] - It is optional. It is returned when division by zero results in an error. When no value is provided then default value is BLANK().
Ex.
EVEN
Returns a number rounded up to the nearest even integer. You can use this function for processing items that come in twos. For example, a packing crate accepts rows of one or two items. The crate is full when the number of items, rounded up to the nearest two, matches the crate's capacity.
Syntax- EVEN(Number)
Number-The value to round.
Ex.
EXP
Returns e raised to the power of given number.
Syntax- EXP(Number)
Number- Number applied as exponent to the base e, where e is equals to 2.71828182845904.
Ex
FACT
Returns the factorial of a number, equals to 1*2*3*4*….* Number.
Syntax- FACT(Number)
Number- Non negative number for which you want the factorial.
Ex.
FLOOR
Rounds a number down, toward zero, to the nearest multiple of significance.
Syntax - FLOOR(Number, Significance)
Join the conversation! Your thoughts help the community grow.