In this article
CUBEMEMBERPROPERTY returns a property of a member, such as a product’s category or a customer’s city, from the model. Cube functions read from a Power Pivot Data Model (connection “ThisWorkbookDataModel”) or an Analysis Services cube.
Advertisement
Syntax
=CUBEMEMBERPROPERTY(connection, member_expression, property)| Argument | What it means |
|---|---|
connection |
“ThisWorkbookDataModel” for Power Pivot |
… |
Member, set or KPI expressions in MDX form |
Examples
Example 1
=CUBEMEMBERPROPERTY(connection, member_expression, property)Result: (value from your Data Model). See the worked example table below for more cases.
CUBEMEMBERPROPERTY 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 | =CUBEMEMBERPROPERTY(connection, member_expression, property) | (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? |
Related functions
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.
Free · AI can be wrong