Following Are The Steps For Adding Prefix And Suffix

1. Load Your Data:

• 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:

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

3. Select the Column to Modify:

• Click on the column to which you want to add a suffix or prefix.

4. Add Prefix or Suffix:

• Go to the "Transform" tab.

• Click on the "Format" dropdown menu.

• Select "Add Prefix" or "Add Suffix" from the options.

• Enter the desired prefix or suffix in the dialog box that appears.

5. Apply Changes:

• Click "OK" to apply the prefix or suffix to the column.

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

This method allows you to easily add a prefix or suffix to your columns without needing to write any formulas