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!
Go to Solution.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Best regards, JiHwan Kim
View solution in original post
For creating a new table, please try the below.
New Table =SUMMARIZECOLUMNS ('Table'[ID],"column1", AVERAGE ( 'Table'[column1] ),"column2", AVERAGE ( 'Table'[column2] ))
Measure 4 = AVERAGE('Table 1'[column1])
Measure 5 = AVERAGE('Table 1'[column2])
Proud to be a Super User!
New Animated Dashboard: Sales Calendar
I'm sorry I should have mentioned. I would like to do this in the power query/transform data query editor.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.