Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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?
Solved! Go to 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.
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.
@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 |
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!