Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Grouping Columns

I've got a table that organizes like the following: Date Type A1 A2 B1 B2 B3 1/1/2022 Red 2 3 1 3 3 1/2/2022 Blue 3 2 2 0 2 1/3/2022 Green 2 3 3 3 1   I ...
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Anonymous 

not sure if i fullly get you. you can create a table like this:

SumTable2 =
SELECTCOLUMNS(
    data, 
    "Date", data[Date], 
    "Type", data[Type], 
    "A", [A1]+[A2], 
    "B", [B1]+[B2]+[B3]
)

i works like this: