Replace value inside a table reading other table

[AlessandroBet]

Hi,

i have 2 tables with several columns

Tab1

Col1 Col2 Col3 ....etc

RawA

RawB

Tab2

Col1 Col2 Col3 ....etc

RawA

RawB

When i match the same value on Tab1 Col1 RowA and Tab2 Col1 RowA have to replace the value on Tab1 Col2 RowA with Tab2 Col2 RowA

can anyone help me?

[v-stephen-msft · Accepted solution]

Hi @AlessandroBet ,

You can create a relationship between two tables and then use the RELATED() function.

Sample data:

Table1

Table2

Relationship:

Add a calculated column with the above fuction to return the Value 2 with the same name in Table 2.

Modify it to return the Value1 when it is blank.

Column = var _v2=RELATED('Table2'[Value2])
return IF(ISBLANK(_v2),[Value1],_v2)

Best Regards,

Stephen Tao

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

[daXtreme]

That's a job (easy) for Power Query.