Forum Discussion
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"...
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
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!
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