How to Add / Modify Field in Current Table

Hi Anonymous ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data.  

Table:

Table (2):

(2)Go to the Add Column tab and Add an Index Column [from 0] and name it Index.

(3)Add a Custom Column with this expression: Table2[ColumnName]{[Index]}

such as:

(4)Delete the previous PBI_Application and index columns, and change the column names of the custom columns to PBI_Application.

(5)Then the result is as follows.

Please refer to the following document for more information.

Power BI: How to Add Column from Another Table (windowsreport.com)

Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.