CUBEKPIMEMBER Function in Excel: KPI Value From a Data Model

⏱ 1 min readUpdated 5 October 2026

CubeLevel: ExpertAvailable in: Excel 2007+

In this article

Syntax
Examples
Example 1
CUBEKPIMEMBER in practice
Where you will use it
Worked example
Mistakes people make
Related functions

CUBEKPIMEMBER returns a KPI property (value, goal, status, trend) from an OLAP cube or Power Pivot model. Cube functions read from a Power Pivot Data Model (connection “ThisWorkbookDataModel”) or an Analysis Services cube.

Syntax

=CUBEKPIMEMBER(connection, kpi_name, kpi_property, )

Argument	What it means
`connection`	“ThisWorkbookDataModel” for Power Pivot
`…`	Member, set or KPI expressions in MDX form

Examples

Example 1

=CUBEKPIMEMBER(connection, kpi_name, kpi_property, )

Result: (value from your Data Model). See the worked example table below for more cases.

CUBEKPIMEMBER in practice

Where you will use it

Custom report layouts that PivotTables can't do
Top-N lists with CUBESET + CUBERANKEDMEMBER
Finance packs from a data model

Worked example

Workbook	Formula	Result
Has a Data Model	`=CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])`	(value from your Data Model)

Needs a Power Pivot Data Model, so this example is not calculated here: the result is whatever your model holds.

Mistakes people make

Mistake	What to do instead
Typos in member names	Build them with PivotTable > OLAP Tools > Convert to Formulas
No data model	#N/A or #NAME?

CUBEVALUE · CUBESET · CUBEMEMBER

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Model Free · AI can be wrong