Forum Discussion
Solved
Query editor replacing values based on another column
I am trying to change the subdivision name from "Asset Management" to "Land Use Office" for those items where the the department is "land use office" I can't figure out the query editor language, se...
We ended up just adding a custom calculated column to do make the adjustment. See text below. To make it a little cleaner, we will add the other replace value steps into the custom calculated colum.
#"Added Custom" = Table.AddColumn(#"Replaced OTP3", "Res", each if [Department] = "Land Use Office" then "Land Use Office" else [Subdivision Name]),
We ended up just adding a custom calculated column to do make the adjustment. See text below. To make it a little cleaner, we will add the other replace value steps into the custom calculated colum.
#"Added Custom" = Table.AddColumn(#"Replaced OTP3", "Res", each if [Department] = "Land Use Office" then "Land Use Office" else [Subdivision Name]),