Forum Discussion
Solved
Power BI Replace if multiple conditions
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 ch...
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
Community Champion
Community Championelainepowell Any chance you can paste some sample data as text?
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 |