COMBINA function

Description

Returns the number of combinations (with repetitions) for a given number of items.

DAX COMBINA function is new in Excel 2016.

Syntax

COMBINA (<number>, <number_chosen>)

Parameters

Sr.No. Parameter & Description
1

number

The number of items.

Must be greater than or equal to 0, and greater than or equal to number_chosen.

Non-integer values are rounded.
2

number_chosen

The number of items in each combination.

Must be greater than or equal to 0.

Non-integer values are rounded.

Return Value

A whole number.

Remarks

  • If the value of either parameter is outside of its constraints, COMBINA returns #ERROR.

  • If either parameter is a non-numeric value, COMBINA returns #ERROR.

The following equation is used, where N is number and M is number_chosen −

$$\left(\begin{array}{c}N\:+\:M\:-1\\ N\:-\:1\end{array}\right)$$

Example

= COMBINA (5,2) returns 15. 
= COMBINA (5.4,2) returns 15. 
= COMBINA (5.5,2) returns 21.
dax_functions_mathematical_trigonometric.htm
Advertisements