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...
https://support.microsoft.com/en-us/office/cubemember-function-0f6a15b9-2c18-4819-ae89-e1b5c8b398ad: 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