Question: Working with the same data ( which is currently in a csv file ) , you would like to convert the positions of First Baseman,
Working with the same data which is currently in a csv file you would like to convert the positions of First Baseman, Second Baseman, Third Baseman, and Shortstop to be identified as just "Infielder." In which of the following ways would it be possible to make this conversion? Choose all that apply.
Question options:
Create a Conditional Column in Power Query
Import the data into an Excel sheet and use Text to Columns.
Import the data into an Excel sheet and use Find and Replace
Use Replace Values in Power Query
Create a new measure for infielders in Power Pivot
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
