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...
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 💡
Apologies this was supposed to be in the Power Query forum and posted here by mistake Idrissshatila
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 💡