Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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:
Appreciate any help and guidance on this one, thanks in advance!
Solved! Go to Solution.
Hi lbendlin ,thanks for the quick reply, I'll add more.
Hi @dcheng029 ,
Try using the 'Merge' operation in Power Query.
Best Regards
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.
Hi lbendlin ,thanks for the quick reply, I'll add more.
Hi @dcheng029 ,
Try using the 'Merge' operation in Power Query.
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
User | Count |
---|---|
84 | |
81 | |
65 | |
52 | |
46 |
User | Count |
---|---|
100 | |
48 | |
42 | |
39 | |
38 |