Forum Discussion
AdWords avg. position calculation
Perfect, I created a column using this formula:
WeightedAverage = ([Impressions] * [Avg. position]) / [Impressions]
I also created a measure like this:
mWeightedAverage = (SUM(Sheet2[Impressions]) * AVERAGE(Sheet2[Avg. position])) / SUM(Sheet2[Impressions])
Hey!
Is this better? I exported some of the data from the table I'm using.
https://docs.google.com/spreadsheets/d/1msWrta5KOl1SsnC5sqIU2yOlBHDAlkr2zOWQ4TQLIvE/edit?usp=sharing
Perfect, I created a column using this formula:
WeightedAverage = ([Impressions] * [Avg. position]) / [Impressions]
I also created a measure like this:
mWeightedAverage = (SUM(Sheet2[Impressions]) * AVERAGE(Sheet2[Avg. position])) / SUM(Sheet2[Impressions])
Wow! Such a simple solution! Thank you so much for all your help smoupre!! The figures are pretty close to our Excel reports (we're switching from Excel to Power BI). Interesting that instead of a sum, simply switching [Avg. position] to an average does the trick. Neat! Thanks again! :smileyhappy:
hello
do you know how this could possibly work with Search Console data
where I have
Keyword / total position / clicks / impressions
dyingod wrote:Wow! Such a simple solution! Thank you so much for all your help smoupre!! The figures are pretty close to our Excel reports (we're switching from Excel to Power BI). Interesting that instead of a sum, simply switching [Avg. position] to an average does the trick. Neat! Thanks again! :smileyhappy:
