Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Replace/Translate UserID's into UserNames

1) I have imported a database table into Power BI , and it contains "UserID" values 2) I have exernal CSV file that contains UserID and UserName columns  3) Now, i would like to replace/translate  ...
Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    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. 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

my thoughts have not changed from my earlier reply.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.