How to calculate averages using power query in excel

It can be done, but I don't recommend you to do it now because it requires writing some code, and I believe writing code is not a good thing for a novice.

If it is just to solve your problem, the pivot table can do it.

It's a matrix in Power BI, you can find it in the visuals, and you can drag and drop what you want to visualize, please check below:

If this helped you, you can mark my post as solution or give a thumb up 😊