CUBESETCOUNT Function in Excel: Number of Items in a Set
CUBESETCOUNT counts the items in a set made with CUBESET. Cube functions read from a Power Pivot Data Model (connection "ThisWorkbookDataModel") or an Analysis…
Read article →Cube
Excel Cube functions explained with syntax, examples and common mistakes.
📊
← Excel
Cube
Excel Cube functions explained with syntax, examples and common mistakes.
📄 7 articles⬇️ 3 with practice files🕒 Updated 13 Oct 2026
🎓 Start here: Excel for India Course → 🎓 Start here: Excel Course: Beginner → Expert → 🎓 Start here: Bank Statement Automation →CUBESET Function in Excel: A Set of Members for Top-N Reports
CUBESET Function in Excel: A Set of Members for Top-N Reports
CUBESET defines a sorted set from the Data Model — combine it with CUBERANKEDMEMBER for top-10 lists that update themselves.
Read article →CUBEVALUE Function in Excel: Numbers Straight From the Data Model
CUBEVALUE Function in Excel: Numbers Straight From the Data Model
CUBEVALUE pulls a measure from the Power Pivot Data Model into any cell, so you can build free-form reports instead of being stuck with…
Read article →CUBEMEMBER Function in Excel: A Label From the Data Model
CUBEMEMBER Function in Excel: A Label From the Data Model
CUBEMEMBER returns a member (like a year or product) from the Data Model, which CUBEVALUE can then reference.
Read article →CUBERANKEDMEMBER Function in Excel: The n-th Member of a Set
CUBERANKEDMEMBER Function in Excel: The n-th Member of a Set
CUBERANKEDMEMBER returns the n-th member of a set, e.g. the 1st, 2nd and 3rd best customers from a CUBESET: the way to build Top-N…
Read article →CUBEKPIMEMBER Function in Excel: KPI Value From a Data Model
CUBEKPIMEMBER Function in Excel: KPI Value From a Data Model
CUBEKPIMEMBER returns a KPI property (value, goal, status, trend) from an OLAP cube or Power Pivot model. Cube functions read from a Power Pivot…
Read article →CUBEMEMBERPROPERTY Function in Excel: Property of a Cube Member
CUBEMEMBERPROPERTY Function in Excel: Property of a Cube Member
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…
Read article →