Forum Discussion
ThomasSan
Helper IV
Helper IVReplace 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...
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.
ThomasSanHelper IV
Helper IVHi AlexisOlson ,
thank you for your reply. You are right, {32} was an error. Having applied your formula, however, I only get errors generated in column1.
Do you have any idea where the problem lies?
P.S.: = #"Transposed Table"{30}[Column2] is at least generating the right value (i.e. 2019)
AlexisOlson
Super User
Super UserWhat 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
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"})