Forum Discussion

AaronGlenn10's avatar
AaronGlenn10
Icon for Helper III rankHelper III
5 years ago
Solved

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 metropo...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    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
     
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

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
 
  • AaronGlenn10's avatar
    AaronGlenn10
    Icon for Helper III rankHelper III
    5 years ago

    I'll do it manually.

  • AaronGlenn10's avatar
    AaronGlenn10
    Icon for Helper III rankHelper III
    5 years ago

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

    • selimovd's avatar
      selimovd
      Icon for Most Valuable Professional rankMost Valuable Professional
      5 years ago

      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