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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
AaronGlenn10
Helper III
Helper III

Consolidating 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

1 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
 

View solution in original post

4 REPLIES 4
selimovd
Super User
Super User

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
 

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

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
 

I'll do it manually.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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