cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mahra-in
Helper I
Helper I

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
anandraman
Helper I
Helper I

Try this calculated column

 

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

View solution in original post

2 REPLIES 2
anandraman
Helper I
Helper I

Try this calculated column

 

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

View solution in original post

Zubair_Muhammad
Community Champion
Community Champion

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

Regards
Zubair

Please try my custom visuals


Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors