Following Are The Steps For Extracting Left - Right - & Mid Data Into Different Columns

Extracting Left Portion

1. Load Your Data:

1. • Open Power BI and load your dataset.

   • Go to the "Home" tab and click on "Transform Data" to open the Power Query Editor.

2. Open Power Query Editor:

1. • In the Power Query Editor, select the table that contains the column you want to modify.

3. Select the Column to Extract From:

1. • Click on the column from which you want to extract the left portion.

4. Extract Left:

• Go to the "Add Column" tab.

• Click on "Extract" and select "Text Before Delimiter" or "First Characters".

• If you choose "First Characters", specify the number of characters to extract from the left.

Extracting Right Portion

1. Select the Column to Extract From:

1. • Click on the column from which you want to extract the right portion.

2. Extract Right:

• Go to the "Add Column" tab.

• Click on "Extract" and select "Text After Delimiter" or "Last Characters".

• If you choose "Last Characters", specify the number of characters to extract from the right.

Extracting Mid Portion

1. Select the Column to Extract From:

1. • Click on the column from which you want to extract the mid portion.

2. Extract Mid:

• Go to the "Add Column" tab.

• Click on "Extract" and select "Range".

• Specify the starting position and the number of characters to extract.

Apply Changes

• Click "Close & Apply" in the Power Query Editor to apply the changes and return to the main Power BI window.

Your column should now have the extracted portions based on your specified criteria.