PL-300 Question 40

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose D3

  all 4 solutions will lead to the desired result. But A,B,C will require additional steps.

• Chose D5

  D. Transform the column to contain only the year. You can do this by selecting the "Date" column, then choosing Transform > Date > Year in Power Query Editor, which will automatically convert the column to show only the year.

• Chose D3

  D. Transform the column to contain only the year is the fastest and most efficient method in Power Query.