Forum Discussion
Cube function and measures
Hello,
I'm learning to use the cube function, from someone else's file.
But I can't figure out how to incorporate a scale into my results.
The file uses this formula to, I think, format the results: =MEMBRECUBE("ThisWorkbookDataModel";"[Measures].[k€]")
Even if I copy the formula, the result returns #N/A.
Does anyone have a solution, please?
CUBEMEMBER: Returns a member or tuple from the cube. Use to validate that the member or tuple exists in the cube
If =CUBEMEMBER("ThisWorkbookDataModel";"[Measures].[k€]") returns #N/A the most probable reason is: no measure named 'k€' exists in your Data Model. If such a measure exists the result will be k€ and nothing else
I guess MEMBRECUBE in English version is CUBEMEMBER. In general it shall work. If you type from scratch it shall suggest you available options, did you try?
