Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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.
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.
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