Forum Discussion
List.average by quarter and year
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
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
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.
2 Replies
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
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.