Forum Discussion
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 😊
I'm wanting to do it using power query editor - is this Power BI? This:
- MattiaFratello
Super User
Hi Paula, yes, this looks like Power BI. Instead of doing it within Power Query I think it's best to import the data in Power BI and do it through the visualizations.
Hello and thanks for your reply - sorry I'm not sure what that means or how to do it!
- MattiaFratello
Can you share en Execle file with no sensitive data pls?