June 20, 2020
how to create measure formula in power pivot . i want to calculate average based on value in column show in current pivot table
|I MANAGE EXPECTATIONS Total||85%||86%||Average in column value|
|I OWN IT Total||51%||54%|
|I’M AN EXPERT Total||82%||82%|
August 21, 2019
are you able to upload a sample of your worksheets ? are these sectors tagged with a group name ? if yes it will be easier to use Group By in Power Query ( you mentioned power pivot)
or you just want to use power pivot to cleanse and transform into the three average values, what is the Grand Total? how you got 78%
October 17, 2018
I would be careful of the average of the percentages concept. Unless you are absolutely sure that the percentages are always calculated based on the same denominator. Different denominators could skew your analysis.
760/1000 = 76%
29/30 = 97%
51/60 = 85%
The combined weighted average info results in 840/1090 which is 77% not the 86% that the above shows ((76%+97%+85%) /3).
Just some food for thought.