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 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?
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.
3 Replies
- Greg_Deckler
Community Champion
elainepowell 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
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.
