List.average by quarter and year

[Fantmas]

Hi Everyone,

I would like to create a new column with the average by quarter & year and I struggling to apply the average function in power query,

Can you help me

Thanks

[ppm1 · Accepted solution]

You can just Group By your year and month and choose average for the aggregation for your column. However, if you want to keep all your rows, you should just calculate your average with a DAX measure.

Pat

[v-stephen-msft · Accepted solution]

Hi @Fantmas ,

Is that your problem solved?

If not, I made a simple sample for reference.

Sample data:

1.Hold Ctrl and both select Year and Quarter columns and right-click to choose "Group By...".

2.The Average column is grouped based on year and quarter, and the All Rows column is for keeping original rows.

3.Expand it.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[ppm1 · Accepted solution]

You can just Group By your year and month and choose average for the aggregation for your column. However, if you want to keep all your rows, you should just calculate your average with a DAX measure.

Pat