Forum Discussion
Solved
Replace value from row number
Dear all, If I have a column below: Col 1 1 2 3 4 5 6 7 2 2 2 And I want to replace 2 to 10 but only apply from row 3, the result will be like: Col 1 1...
I found the solution. Add the index column, then write below code:
= Table.ReplaceValue(#"Added Index",each [Column1], each if [Column1] = 2 and [Index] > 3 then 10 else [Column1],Replacer.ReplaceValue,{"Column1"})
Right click your column > replace values
A dailog box will pop up just enter 2 in the "Values to find" and 10 in the "Replace with"
this action will replace all value 2 to 10. My expecting is keeping value 2 at row number 2, only replace from row number 3 to end of column