Forum Discussion
Replace values and rename headers based on lookup table
Hi Anonymous ,
in the sample data in the original post you have column headers in "sentence" case (i.e. "Old values"), but in the same file you shared, they are in "Capitalise Each Word" case (i.e. "Old Values"). Power BI is quite case-sensitive.
Please rename headers in your file to match the original post. 😁
I also sent you a link to your updated file, it contains the code that works with the column headers as they currently appear in the file (i.e. "Old Values").
Kind regards,
JB
Hi JB,
Thanks for your reply 🙂 - very quick!
Unfortunately that didn't seem to work for me.
I have uploaded the Excel Workbook with all the tables/connections to Google Drive, if that helps!?
See Excel doc here - https://drive.google.com/open?id=1RIwZ03veLlx71PUy86_HaYbptKKy9VWS
Thanks for your help, really appreciate it.
Cheers,
James
Hi Anonymous ,
in the sample data in the original post you have column headers in "sentence" case (i.e. "Old values"), but in the same file you shared, they are in "Capitalise Each Word" case (i.e. "Old Values"). Power BI is quite case-sensitive.
Please rename headers in your file to match the original post. 😁
I also sent you a link to your updated file, it contains the code that works with the column headers as they currently appear in the file (i.e. "Old Values").
Kind regards,
JB
Hi, Can you please share the solution here? I have a similar case.
JB, thank you so much. This worked perfectly 🙂 Thank you! J