Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Ksyokz23
Frequent Visitor

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. What will be the best Power Query approach to have only one format for the state = Nevada and have the Medical Centers locations fall under the Nevada State when you apply the filter. Diagram below shows the Location Column that needs to be cleaned up. Keep in mind I have no access to the Data Source.

Before 

Ksyokz23_0-1700606514998.png

 Thank you in Advance

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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. 

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Don't you have State field in the db table ? 

There is no State field

 

That is the only Location Column they have in the report

Anonymous
Not applicable

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.