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"})
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"})