Cube

CUBEKPIMEMBER Function in Excel

Returns a key performance indicator (KPI) property.

Syntax

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

Arguments

  • connection (required): Connection string to cube
  • kpi_name (required): Name of the KPI
  • kpi_property (required): Property (1=Value, 2=Goal, 3=Status, etc.)
  • caption (optional): Display text

Examples

  • =CUBEKPIMEMBER("Sales", "Revenue Growth", 1) - Get KPI value - Result: KPI value

CUBEKPIMEMBER and data models

  • Validate members with CUBEMEMBER before CUBEVALUE.
  • Confirm the connection name matches your Power Pivot or OLAP model.
  • Explore summaries with [Pivot tables guide](/guides/excel-pivot-tables-guide/).

Common errors

  • #N/A if KPI not found

Use cases

  • KPI dashboards
  • Performance monitoring
  • Business intelligence

Frequently asked questions

  • What is the CUBEKPIMEMBER function in Excel? CUBEKPIMEMBER returns a key performance indicator (KPI) property. The syntax is =CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption]). Typical use cases include kPI dashboards, performance monitoring, business intelligence.
  • How do I use the CUBEKPIMEMBER function? To use CUBEKPIMEMBER, type =CUBEKPIMEMBER( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • Why is CUBEKPIMEMBER not working in my Excel? Common issues with CUBEKPIMEMBER include #N/A if KPI not found. Start by checking the syntax =CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption]), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.