Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Replace values and rename headers based on lookup table

Hi there,    I hope I am posting this in the correct place, it is my first time on this forum. 🙂   I would like to create a function which replaces values in a column based on a 'lookup' table a...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

     

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

 

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi, Can you please share the solution here? I have a similar case.