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.

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

Useful Video Courses

Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours