cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mahra-in Regular Visitor
Regular Visitor

replace values

Could someone please hep to replace the values in editor

 

I have 2 tables

 

Table 1:

 

IdName
1America
2Australia
3Denmark
4India
5China

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
anandraman Regular Visitor
Regular Visitor

Re: replace values

Try this calculated column

 

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

View solution in original post

2 REPLIES 2
Super User
Super User

Re: replace values

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

Try my new Power BI game Cross the River
anandraman Regular Visitor
Regular Visitor

Re: replace values

Try this calculated column

 

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

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)