Compare CUBEKPIMEMBER vs CUBEVALUE

2 vs

Compare CUBEKPIMEMBER vs CUBEVALUE side-by-side — differences, popularity and recommendation

Presets: VLOOKUP vs XLOOKUP SUM vs SUMIFS INDEX vs MATCH vs XLOOKUP IF vs IFS vs SWITCH COUNT vs COUNTA vs COUNTIF AVERAGE vs AVERAGEIF vs AVERAGEIFS MAX vs LARGE vs MIN TEXT vs TEXTJOIN vs CONCAT FILTER vs SORT vs UNIQUE ROUND vs ROUNDUP vs ROUNDDOWN

All functions Pick at least 2 functions

Feature

Cube

=CUBEKPIMEMBER()

Syntax

Cube

=CUBEVALUE()

★ Winner

Syntax

Category

Cube cube

Popularity

8 / 100

35 / 100

Views

◉ 20 views

◉ 33 views

Output

Mixed

Version

Excel 2007

Volatile

Dynamic Array

Description

Returns a key performance indicator (KPI) property and displays the KPI name in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, that is used to monitor an organization's performance.

Returns an aggregated value from the cube.

Syntax

=CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])

=CUBEVALUE(connection, [member_expression1], [member_expression2], …)

Arguments

5 Arguments

connection kpi_name kpi_property if (Optional) caption (Optional)

2 Arguments

connection member_expression (Optional)

Examples

Tips

★ Recommendation — Winner: =CUBEVALUE()

=CUBEVALUE() is recommended based on higher popularity, newer version and Dynamic Array support.

Winner: =CUBEVALUE()