Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

Click one of the links in the following list to see detailed help about the function.

Function

Description

CUBEKPIMEMBER function

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.

CUBEMEMBER function

Returns a member or tuple from the cube. Use to validate that the member or tuple exists in the cube.

CUBEMEMBERPROPERTY function

Returns the value of a member property from the cube. Use to validate that a member name exists within the cube and to return the specified property for this member.

CUBERANKEDMEMBER function

Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or the top 10 students.

CUBESET function

Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Excel.

CUBESETCOUNT function

Returns the number of items in a set.

CUBEVALUE function

Returns an aggregated value from the cube.

Excel functions (by category)

Excel functions (alphabetical)

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×