Forum Discussion
Solved
Clean up Similar Location/US State column in Power Query
I have a request to clean up the messy Location column, (NV Central, Nevada Region, Nevada or NV) should fall under Nevada and the Medical Centers should fall under Nevada when you apply the Filter. ...
Then you might have to write conditional columns statements if city is Las Vegas or Reno or if it contains NV Or Nevada then state = Nevada
you may have to accommodate for many scenarios.
There is no State field
That is the only Location Column they have in the report
Then you might have to write conditional columns statements if city is Las Vegas or Reno or if it contains NV Or Nevada then state = Nevada
you may have to accommodate for many scenarios.
Thanks Dan add a conditional column using the if statement