As the title suggest, I'd like to replace the values of column x that contain in Text - Copy with "" (Blank/null)
I've tried the following but it does not seems to work to my ideal result.
= Table.ReplaceValue(#"Duplicated Column",each [x],"",Replacer.ReplaceValue,{"Text - Copy"})
This would be the ideal result that I'd like to yield
I've tried to use this as was given, but it doesnt yield the ideal result.
= Table.ReplaceValue(#"Duplicated Column",each [x],"",Replacer.ReplaceText,{"Text - Copy"})
question from:
https://stackoverflow.com/questions/65623626/power-query-replacing-specific-value-based-on-another-column 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…