cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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 I
Super User I

Re: replace value based on two factors in query editor

@Anonymous 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 !





View solution in original post

1 REPLY 1
Super User I
Super User I

Re: replace value based on two factors in query editor

@Anonymous 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 !





View solution in original post

Helpful resources

Announcements
June 2020 Community Challenge: Can You Solve These?

June 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors