Question 80 of 388
Single answerYou 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?
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.
✓
Correct Answer: C
Change the Aggregate Value Function of the pivot.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.