Update values in other collumn-table based in other table-collumn

[Jan845]

Hey guys,

I have two tables in my PBI project.

I want to use the second table just for update the values in one collumn on "Table 1"

Example

Table 1:

Nº ID	Data	Status
122	10/10/2022	Open
2322	11/10/2022	Closed
2333	12/10/2022	Open
4544	13/10/2022	Pending
23123	14/10/2022	Open
5554	15/10/2022	Open
3343	16/10/2022	Open
9088	16/10/2022	Pending
89891	16/10/2022	Pending
87872	16/10/2022	Pending
86863	16/10/2022	Pending
66543	16/10/2022	Pending

Table 2

Nº ID	Data	Status Related
122	10/10/2022	Closed
2322	11/10/2022	Closed
2333	12/10/2022	Closed
4544	13/10/2022	Closed
23123	14/10/2022	Closed
5554	15/10/2022	Closed
3343	16/10/2022	Closed
9088	16/10/2022	Closed
89891	16/10/2022	Closed
87872	16/10/2022	Closed
86863	16/10/2022	Open
66543	16/10/2022	Open

The values on my table 2 will updated 2x per day in excell online synced with powerbi with schedule refresh.

When i update the values in Table 2 on collumn "Status Related" i want it to automatically update the status in table 1 on Collumn "Status" but if the value on collumn "Nº ID" on Table 2 be equal to  "Nº ID"  on "Table 1"

I tried to create relationship between two tables and I created a related collumn in Table 1 , but I just wanted to update the "Status" column on Table 1 and not create another column

Any simple way to do this status update in table 1, only if the NºID  is the same in two columns?

Thank you for all help.

[Jan845]

Thank you @v-yadongf-msft  you help me a lot! 

[v-yadongf-msft · Accepted solution]

Hi @Jan845 ,

This is my test table1:

Test table2:

Create a new column in table1:

Status Related = LOOKUPVALUE('Table2'[Status Related],'Table2'[Nº ID],'Table1'[Nº ID])

If I modify data in excel and save data:

Refresh data in Power BI, both tables are refreshed.

Table2:

Table1:

Best regards,

Yadong Fang

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