cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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 Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (5,050)