Forum Discussion

ThomasSan's avatar
ThomasSan
Icon for Helper IV rankHelper IV
4 years ago
Solved

Replace text with content from other column

Hi everyone,   I am attempting to dynamically replace the headers of my table. My headers contain the string BLY, LY and CY which stand for "Before Last Year", "Last Year" and "Current Year", respe...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    What is the error message?

     

    If it's complaining that 2019 isn't text, then you can wrap #"Transposed Table"{30}[Column2] with Text.From.

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

What is the error message?

 

If it's complaining that 2019 isn't text, then you can wrap #"Transposed Table"{30}[Column2] with Text.From.

ThomasSan's avatar
ThomasSan
Icon for Helper IV rankHelper IV
4 years ago

AlexisOlson 

great, that was the final key! Thanks a lot for your help!

 

 

for others

the final formula should read 

 

= Table.ReplaceValue(#"Transposed Table","BLY",Text.from(#"Transposed Table"{30}[Column2]),Replacer.ReplaceText,{"Column1"})