Microsoft
70-779 · Question #26
You have a KPI named Goal that calculates the sales from the previous year and multiplies the sales by 1.1. You need to modify Goal to multiply the sales from the previous year by 1.15. What should…
The correct answer is A. From Power Pivot, modify the measure. You can't modify the KPI base field directly. Just the measure behind it.
Model data by using Microsoft Excel
Question
You have a KPI named Goal that calculates the sales from the previous year and multiplies the sales by 1.1. You need to modify Goal to multiply the sales from the previous year by 1.15. What should you do?
Options
- AFrom Power Pivot, modify the measure.
- BFrom the properties of the KPI, modify the KPI base field.
- CFrom Power Pivot, create a new calculated column, and then modify the KPI.
- DFrom the properties of the KPI, modify the absolute value.
How the community answered
(17 responses)- A71% (12)
- B18% (3)
- C6% (1)
- D6% (1)
Explanation
You can't modify the KPI base field directly. Just the measure behind it.
Topics
#KPI#Power Pivot#DAX measures#calculated measure
Community Discussion
No community discussion yet for this question.