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 result...
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