Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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: ...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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,

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

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,