Multiply column in the same column using a filter or if clause

Hi Olha_Protsak ,

I think you want to use Table.ReplaceValue, something like this:

= Table.ReplaceValue(
    previousStep,
    each [Total of Capsules_L],
    each if [Legal Entity Label (Entity)] = "Germany"
        then [Total of Capsules_L] * 1000
        else [Total of Capsules_L],
    Replacer.ReplaceValue,
    {"Total of Capsules_L"}
)

Pete