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
Highlighted
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
Highlighted
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 Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)