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 row3. The solution must preserve all…

The correct answer is D. Change the Aggregate Value Function of the pivot. https://docs.microsoft.com/en-us/power-bi/desktop-common-query-tasks

Consume and Transform Data by Using Power BI Desktop

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 row3. The solution must preserve all the data. What should you do?

Exhibits

Options

AChange the Data Type of the Value column.
BSelect the Score column, and then click Remove Errors.
CSelect the Key column, and then click Remove Duplicates
DChange the Aggregate Value Function of the pivot.

How the community answered

(29 responses)

A
10% (3)
B
3% (1)
C
3% (1)
D
83% (24)

Explanation

https://docs.microsoft.com/en-us/power-bi/desktop-common-query-tasks

Topics

#pivot columns#Power Query#aggregate value function#error resolution

Community Discussion

No community discussion yet for this question.

Full 70-778 Practice