Forum Discussion
Repleace values based on other table
Hi Team, I hope you can help me with my problem. I have searched for it but coldn't find perticular answer. I have a table with circa 30 positions where user name was changed from User Name ...
Hi Slorin,
thank you very match for you fast assistance.
Unfortunately I must be doing something wrong. I have two separate sources with those tables (names change -> KN Previous Name List and reviews -> TAT A1).
With the source should I refere on this query?
= Table.ReplaceValue(#"TAT A1",each [Reviewer],each #"KN Previous Name List" {[User Name1=[Reviewer]]} [User Name2],[User Name2],{"Reviewer"} )
Many thanks!