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 3 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!