Microsoft
70-779 · Question #47
You have a measure that is used by a KPI. You need to display the output of the measure in a cell in your workbook. Which Excel function should you use?
The correct answer is A. CUBEVALUE. https://support.office.com/en-us/article/cubevalue-function-8733da24-26d1-4e34-9b3a- https://powerpivotpro.com/2010/06/using-excel-cube-functions-with-powerpivot/
Visualize data by using Microsoft Excel
Question
You have a measure that is used by a KPI. You need to display the output of the measure in a cell in your workbook. Which Excel function should you use?
Options
- ACUBEVALUE
- BVLOOKUP
- CCUBESET
- DLOOKUP
How the community answered
(34 responses)- A79% (27)
- B12% (4)
- C3% (1)
- D6% (2)
Explanation
https://support.office.com/en-us/article/cubevalue-function-8733da24-26d1-4e34-9b3a- https://powerpivotpro.com/2010/06/using-excel-cube-functions-with-powerpivot/
Topics
#CUBEVALUE#KPI#cube functions#measures
Community Discussion
No community discussion yet for this question.