Forum Discussion

Olha_Protsak's avatar
Olha_Protsak
Frequent Visitor
4 years ago
Solved

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

Hello Community,   I was wondering if there is a possibility to multiply columns by constant in the same column with using a FILTER?   So I have a banch of countries in my table, and I need to ch...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    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

BA_Pete's avatar
BA_Pete
Super User
4 years ago

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

  • Olha_Protsak's avatar
    Olha_Protsak
    Frequent Visitor
    4 years ago

    yes that could work as well,

    but i have this message when using the code:

    I have checked and the spelling of columns are correct.

    Do you have the idea what is wrong?

    • BA_Pete's avatar
      BA_Pete
      Super User
      4 years ago

      Hi Olha_Protsak ,

       

      Sorry, I think it should be this because of the brackets:

      [#"Legal Entity Label (Entity)"]

       

      Pete

      • Olha_Protsak's avatar
        Olha_Protsak
        Frequent Visitor
        4 years ago

        Hi again,

        yes it worked. it was strange for me why it was required only for 

        Legal Entity Label (Entity)

        Thanks a lot!