You use Power Query Editor to preview a column named Date as shown in the following exhibit. You need to change the Date column to contain only the year. The solution must minimize administrative…

Splitting the column by delimiter would require identifying and using a delimiter (e.g., '/', '-') and then potentially discarding other parts, which is more complex than a direct date transformation.

Splitting the column by number of characters would necessitate knowing the exact format and character count of the year and then removing the rest, which is less robust and more cumbersome.

Extracting text after a delimiter would likely remove the year or require additional steps to isolate it, which is not the most direct or minimal effort approach for this task.

Power Query Editor provides specific date transformation functions under the 'Transform' tab that can directly extract the year from a date column with a single click. This approach is the most efficient and minimizes administrative effort compared to manual string manipulation.