Groupby Duplicate ID and Average all other Columns

[Anonymous]

Hi, I would like to groupby [ID], which has multiple rows per [ID]. When grouping, I would like the rest of the columns to remain, but to average the values that exist for each duplicate [ID] row.

Here is an example. 

Thanks in advance, I appreciate your continued support! 

Current format: 

ID	column1	column2
1	10	5
1	20	15
2	80	30
2	90	40

Goal

ID	column1	column2
1	15	10
2	85	35

[Jihwan_Kim · Accepted solution]

[Jihwan_Kim]

Hi,

For creating a new table, please try the below.

New Table =
SUMMARIZECOLUMNS (
'Table'[ID],
"column1", AVERAGE ( 'Table'[column1] ),
"column2", AVERAGE ( 'Table'[column2] )
)

[smpa01]

Measure 4 = AVERAGE('Table 1'[column1])
Measure 5 = AVERAGE('Table 1'[column2])

@Anonymous 

[Anonymous]

I'm sorry I should have mentioned. I would like to do this in the power query/transform data query editor.