Analyzing and Visualizing Data with Microsoft Excel — Question 4

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?

Answer options

• A. From Power Pivot, modify the measure
• B. From Power Pivot, create a new calculated column, and then modify the KPI
• C. From the properties of the KPI, modify the absolute value
• D. From the properties of the KPI, modify the KPI base field

Correct answer: D

Explanation

The correct answer is D because modifying the KPI base field allows you to adjust the underlying sales figure used in the KPI calculation. Options A and B are incorrect since they involve changes to measures or creating new columns, which are not necessary for this task. Option C is also incorrect because changing the absolute value does not achieve the required multiplication adjustment.