Power BI Replace if multiple conditions

[elainepowell]

There's duplicate AD data that I need usable.

If there's a specific city name and it's within TX district, I want to add TX to it.

This requires checking for the city name from one column and checking for TX in the district column.

Table.ReplaceValue(
#"previous",
each [AD.physicalDeliveryOfficeName],
each if [AD.physicalDeliveryOfficeName] = "City" and {"AD-person.district"} = "TX"
then "City TX"
else [AD.physicalDeliveryOfficeName],
Replacer.ReplaceText, {"AD.physicalDeliveryOfficeName"}
)

It's not working.

Anyone know how I can fix this?

[elainepowell · Accepted solution]

It looks like it was a glitch with the name of the second column.

On a whim, I renamed the column and now the replace works.

[Greg_Deckler]

@elainepowell Any chance you can paste some sample data as text?

[elainepowell]

The dataset is awkward, but maybe this will work?

AD.physicalDeliveryOfficeName	AD-person.district
Lake Stevens	WA
College Station	TX
Logan	UT
Murray	UT
Kirkland	WA
City	TX
City	OR
Bellingham	WA
Lancaster	CA
Stockton	CA
Santa Rosa	CA
Van Nuys	CA
Pompano	FL
Kendall	FL
Everett	WA
Albuquerque	NM
El Centro	NM
City	TX
City	OR
Visalia	CA
Clovis	CA
Novato	CA
Merced	CA
San Francisco	CA
Livermore	CA
Miami Lakes	FL
N Miami	FL
Staten Island	NY
Brooklyn	NY
Yonkers	NY
Port Chester	NY
Boca Raton	FL
Auburn Hills	MI