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 😊
Super UserCan you share en Execle file with no sensitive data pls?
Yes, thanks - here you go! Names / IDs are not real. It won't let me upload the file, so used WeTransfer
- MattiaFratello
Something like this could work?
Oh yes, thanks. How did you do this? Is this a pivot table would this work with the original data which has over 3500 entries?
- MattiaFratello
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 😊