Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Replacing Existing Value based on 2 columns

Hi 

 

I have 2 columns in a table and I need to replace 1 value in one of the existing columns based on the value of the second column but leave the rest of the values unchanged. 

 

Column 1 = Rule Category

Column 2 = Regulator of rule(s) breached

 

I need to change the value if [Rule Category] = "Communications" and [Regulator of rule(s) breached] = "Information Commissi" then replace [Rule Category] = "Communications" as "Data Protection" but all other values in [Rule Catagory] remain unchanged. 

 

is there a quick and easy way to do this without having to do this manually?

Need Help

3 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    2 years ago

    Hello Anonymous ,

     

    add the following as a calculated column

     

    Column = IF('Table'[Rule Category] = "Communications" && 'Table'[Regulator of rule(s) breached] = "Information Commissi" , "Data Protection",'Table'[Rule Category])

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    Follow me on Linkedin
    Vote for my Community Mobile App Idea 💡

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Apologies this was supposed to be in the Power Query forum and posted here by mistake Idrissshatila 

      • Idrissshatila's avatar
        Idrissshatila
        Super User
        2 years ago

        if you want it in power query it would work as well,  just add a new custom column and add the following formula

         

        if [Rule Category] = "Communications" and [#"Regulator of rule(s) breached"] = "Information Commissi" then "Data Protection" else [Rule Category]

         

        If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

        Follow me on Linkedin
        Vote for my Community Mobile App Idea 💡