Microsoft
70-778 · Question #141
You have a table in Power BI Desktop as shown in the following exhibit. You pivot the columns as shown in the following exhibit. You need to resolve the error in row 3. The solution must preserve…
The correct answer is C. Change the Aggregate Value Function of the pivot. See the full explanation below for the reasoning.
Question
You have a table in Power BI Desktop as shown in the following exhibit. You pivot the columns as shown in the following exhibit. You need to resolve the error in row 3. The solution must preserve all the data. What should you do?
Exhibits
Options
- AChange the Data Type of the Value column.
- BSelect the Key column, and then click Remove Duplicates.
- CChange the Aggregate Value Function of the pivot.
- DSelect the Score column, and then click Remove Errors.
How the community answered
(26 responses)- A8% (2)
- B19% (5)
- C69% (18)
- D4% (1)
Community Discussion
No community discussion yet for this question.