Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to aggregate

  Hi PBI Experts,   I'm new to PowerBI so appreciate anyone's assistance here. How do I aggregate some selected rows below. E.g. I want to group together Australia, Canada and LATAM into a "Other"...
Need Help
  • Johanno's avatar
    Johanno
    7 years ago

    Ok, try this :smileyhappy:

    1. In the Menu bar press Modeling

    2. Click New Column

    3. Paste the code I wrote before, but change the name for the table and if you want to change the name of the column "Region2"

    4. Press Enter

    5. Select your table and drag and drop the new Region2 to the table

Johanno's avatar
Johanno
Continued Contributor
7 years ago

Hi, you could do the grouping by creating a calculated column like:

Region2 = SWITCH(Table1[Region];"Australia";"Other";"Canada";"Other";"Latam";"Other";Table1[Region])

Then you add this column to the table instead of the old one. I guess your percentage would still be right, if not add another screen shot.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Folks, I'm super new to PowerBI. Now even sure how to implement these instructions. I appreciate it though but could someone provide some steps to make this work. Thanks!

    • Johanno's avatar
      Johanno
      Continued Contributor
      7 years ago

      Ok, try this :smileyhappy:

      1. In the Menu bar press Modeling

      2. Click New Column

      3. Paste the code I wrote before, but change the name for the table and if you want to change the name of the column "Region2"

      4. Press Enter

      5. Select your table and drag and drop the new Region2 to the table