replace values

[mahra-in]

Could someone please hep to replace the values in editor

I have 2 tables

Table 1:

Id	Name
1	America
2	Australia
3	Denmark
4	India
5	China

Table 2:

Id
2
3
5
2
5
5
1
2
3
4

Now I want the Id's in Table 2 to be replaced in single shot with Name from Table 1 since I have 'n' number of rows in reality

[anandraman · Accepted solution]

Try this calculated column

Column = LOOKUPVALUE(Table1[Name],Table1[Id],Table2[Id])

[Zubair_Muhammad]

Hi @mahra-in

I believe you can use Merge Queries from the Home Tab of the Query Editor to get Names beside each Table 2 ID.

Then you can delete the ID column