Exam PL-300 topic 3 question 97 discussion

HOTSPOT
-

You use Power Query Editor to review the query shown in the following exhibit.



Each Region value appears only on the row where it first occurred. Each subsequent occurrence of the Region value is blank.

You need to ensure that every row contains the correct non-blank value. The solution must minimize development effort.

Which column should you select, and which action should you perform on the column? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Suggested Answer: