Consolidating Cities into Regions

[AaronGlenn10]

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

[selimovd]

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 regards

Denis

Blog: WhatTheFact.bi

[AaronGlenn10]

I figured out how to do it with the "New Group" function.  Thank you!

[selimovd · Accepted solution]

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 regards

Denis

Blog: WhatTheFact.bi

[AaronGlenn10]

I'll do it manually.