Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Thank you in Advance
Solved! Go to Solution.
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.
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
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