Forum Discussion
How to manually change a specific cell?
Hi!
The easier way to accomplish what you want is first you replace for a standard value, then use the formula bar to edit the code, something like, for example:
From:
= Table.ReplaceValue(
#"Last Step",
null,
"standard",
Replacer.ReplaceValue,
{"ColumnToReplace"}
)
To:
= Table.ReplaceValue(
#"Last Step",
null,
each if [ColumnToAnalyze] = "Value" then "Answer 1" else "Answer,
Replacer.ReplaceValue,
{"ColumnToReplace"}
)If you have trouble to define the expression to replace (bold snippet), create a new column to form the value, then use it here.
Hope I helped you!
Helper IIHi!
The easier way to accomplish what you want is first you replace for a standard value, then use the formula bar to edit the code, something like, for example:
From:
= Table.ReplaceValue(
#"Last Step",
null,
"standard",
Replacer.ReplaceValue,
{"ColumnToReplace"}
)
To:
= Table.ReplaceValue(
#"Last Step",
null,
each if [ColumnToAnalyze] = "Value" then "Answer 1" else "Answer,
Replacer.ReplaceValue,
{"ColumnToReplace"}
)
If you have trouble to define the expression to replace (bold snippet), create a new column to form the value, then use it here.
Hope I helped you!
Thank you so much, I've will try this out.