Power Query - to merge rows and calc avrg on the other columns

carlo cerutti 1 Reputation point
2021-10-08T12:26:27.687+00:00

I haven't found this issue anywhere and it should be easy...

I have a table with the first column weeks numbers and in all the other columns values.
I have multiple rows with the same week number and different values in the other columns

I would need to merge all the rows with the same week number (so to have one row per week) and for each other column to have the average values calculated for that week...

I would like to have it done in the PQ so I can get the calculated table in the excel sheet.

Thanks a lot for your help!

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,630 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Ehren (MSFT) 1,781 Reputation points Microsoft Employee
    2021-10-13T22:01:31.757+00:00

    Hi there. Power Query is no longer supported here on Q&A. Please post your question on https://aka.ms/PQCommunity.

    0 comments No comments