Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
dcheng029
Helper II
Helper II

How to replace values on one column with corresponding values from another source

Hi everyone,

 

I am working with 2 data sources; Data Source 1 is a simple list that has the Staff's Name and their corresponding Staff ID which the system uses. Data Source 2 is a list of Job Numbers and the corresponding Staff ID.

 

How would I be able to replace Data Source 2 Staff ID to the corresponding Staff Name from Data Source 1 via Transform Data?

 

Example:

dcheng029_0-1740359384275.png

 

Appreciate any help and guidance on this one, thanks in advance!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi lbendlin ,thanks for the quick reply, I'll add more.

Hi @dcheng029 ,

Try using the 'Merge' operation in Power Query.

vzhouwenmsft_0-1740365008228.png

vzhouwenmsft_1-1740365042885.png

vzhouwenmsft_2-1740365084039.png

 

Best Regards

View solution in original post

4 REPLIES 4
lbendlin
Super User
Super User

The best way is not to do that.  Let the data model do the work for you.

Hi @lbendlin,

How do I have the data model work for me?

My question was how to replace the values in one data's column using second data's column values when the Staff ID matches?

Cheers.

Anonymous
Not applicable

Hi lbendlin ,thanks for the quick reply, I'll add more.

Hi @dcheng029 ,

Try using the 'Merge' operation in Power Query.

vzhouwenmsft_0-1740365008228.png

vzhouwenmsft_1-1740365042885.png

vzhouwenmsft_2-1740365084039.png

 

Best Regards

Ahhh yesss I completely had a mind blank and forgot about this process option, all solved now thank you for the heads up @Anonymous 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.