Forum Discussion
Helper IIIConsolidating Cities into Regions
All Stars:
I have a table which contains all the restaurant locations by city in the State of Texas. I would like to roll-up or consolidate restaurants into regions for four of the major metropolitan areas in the state - Dallas/Fort Worth, Houston, Austin, and San Antonio. Each region/metropolitan area contains multiple cities [e.g., DFW MA includes 200 cities] - what would be the best approach to create these regions?
Thank you!
~AGS
Hey AaronGlenn10 ,
I'm happy you can solve it with the "New Group" function.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.bi
4 Replies
- selimovd
Most Valuable Professional
Hey AaronGlenn10 ,
you have multiple possibilities to group.
Do you want to do this manually or do you have a file to map?
You could do it in Power Query, with a calculated column or the "New Group" function in PowerBI.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.bi
AaronGlenn10I'll do it manually.
- AaronGlenn10
I figured out how to do it with the "New Group" function. Thank you!
- selimovd
Hey AaronGlenn10 ,
I'm happy you can solve it with the "New Group" function.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.bi