Forum Discussion
Solved
Group by ID and sum a column based on a third column with Power Query.
I have data coming back that look like this: Id Year Amount 1 2010 15 1 2010 20 1 2012 20 2 2010 10 2 2011 30 2 2011 40 2 2011 15 3 2012 10 3 20...
That depends on what you want to show in each other column, since you have fewer rows, you are going to have to determine what to show when those rows are merged for those other Columns. For example, you could add additional aggregates for each column using the max aggregate.
That depends on what you want to show in each other column, since you have fewer rows, you are going to have to determine what to show when those rows are merged for those other Columns. For example, you could add additional aggregates for each column using the max aggregate.
I have the similar issue, Please share if you find any solution to it