cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Grouping/summing rows

Hi, I hope someone can help: I have a simple table like this:

I need to make another table which groups/sums these rows together into new names (new1=A+B, new2=C, new3=D+E+F), like this:

I tried the 'Group' function but I couldn't make it work.

How can this be done?

Thank you very much

1 ACCEPTED SOLUTION
Microsoft Employee

Hi @Anonymous

You may add a column with IF Function.Then drag them to table visual to get the table.

```Column =
IF (
Table1[categories] IN { "A", "B" },
"new1",
IF ( Table1[categories] IN { "D", "E", "F" }, "new3", "new2" )
)```

Or create the table with SUMMARIZE Function.

`Table = SUMMARIZE(Table1,Table1[Column],"Open",SUM(Table1[Open]),"Engaged",SUM(Table1[Engaged]),"Highly",SUM(Table1[Highly]))`

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Microsoft Employee

Hi @Anonymous

You may add a column with IF Function.Then drag them to table visual to get the table.

```Column =
IF (
Table1[categories] IN { "A", "B" },
"new1",
IF ( Table1[categories] IN { "D", "E", "F" }, "new3", "new2" )
)```

Or create the table with SUMMARIZE Function.

`Table = SUMMARIZE(Table1,Table1[Column],"Open",SUM(Table1[Open]),"Engaged",SUM(Table1[Engaged]),"Highly",SUM(Table1[Highly]))`

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

when you load the data (get data), go to Add Column\condtional column.  You should be able to build what you want there as an extra column

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.