Forum Discussion
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 = Ru...
Idrissshatila
Super User
Super UserHello 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 💡
Apologies this was supposed to be in the Power Query forum and posted here by mistake Idrissshatila