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
Highlighted
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 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

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)