Forum Discussion
Replace/Translate UserID's into UserNames
you can do all that in Power Query. Either replace the value in the existing column with the value of the merged column and then remove the merged column, or remove the existing column and rename the merged column to the name of the original column.
In your Power Query steps use "Merge Tables" to combine these two sources into one.
hey lbendlin , I have merged as a new table , but new columns appearing the main report , to better understand i just reframed my question here in reply , as i could not able to edit my old one
1) I have imported a database table into Power BI , and it contains "UserID" values
2) I have an external CSV file that contains UserID and UserName columns
3) Now, I would like to replace/translate all my USER ID values with UserNames in PowerBI table
4) Columns already present in my main Power BI report
user ID manager userID business owner ID
AAA000 AAA000 AAA000
BBB0000 BBB0000 BBB0000Ex: my CSV table
UserID UserName
AAA0000 Alice
BBB0000 Bob
how can I replace/map the USerID column wih userName column values wherever it matches
My final table should be as below
user ID manager userID Business owner ID
Alice Alice Alice
Bob Bob Bobplease let me know your thoughts
my thoughts have not changed from my earlier reply.
I did merge those two sources into one , but new columns have been generated , but i am looking for replacing/converting the already existing UserID values into Username from my second source where it matches.