cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
miba Member
Member

replace value based on two factors in query editor

hi 

 

I would like to replace some records in one of my tables based on two criteria

In the example below i have region, city and sales org code. 

The Sales org code changed in the database but it is not reflecting retrospectivaly.

What i would like to do is to replace the sales or for amsterdam from the old I1 to I7

so if i could create a custome column in query editor that woudl say something like

 

= IF [city]=Amsterdam AND [sales org] = I1 THEN I7 ELSE [sales org]

 

Regioncitysales org
EUAmsterdamI1
EUAmsterdamI7
EUZwoleI7
EUUtrechtI7
EULondonI3
USNew YorkI6

 

i am also open to other solutions 

 

tahnk you 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: replace value based on two factors in query editor

@miba Please try this in "Power Query Editor" using "Custom Column"

 

=if [City]="Amsterdam" and [SalesOrg] = "I1" then "I7" else [SalesOrg]

image.png



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





1 REPLY 1
Super User
Super User

Re: replace value based on two factors in query editor

@miba Please try this in "Power Query Editor" using "Custom Column"

 

=if [City]="Amsterdam" and [SalesOrg] = "I1" then "I7" else [SalesOrg]

image.png



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !