How to Add / Modify Field in Current Table

[Anonymous]

Hello Red, I need help regarding a case that I currently have.

I'm working on a report that already has a series of tables defined, which are all related to each other with joins. Now, I have a request to replace / change the value of an existing field in one of the tables for a new one whose table is not in the report, how can I do that inclusion / modification of only that field?

I explain more graphically:

1 - This is the Current tables, marked in yellow: Table.Field which I need to change/modify:

2 - Here the Field (with the Table) that I need to add to replace the previously indicated field:

It is possible to make this using Power Query?

I hope you can help me and I thank you in advance.

[Anonymous · Accepted solution]

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. 

[Anonymous]

Hi @Anonymous Thank you very much for your answer, it worked extremely well for what I wanted... Regards!