Forum Discussion
Helper IAdWords 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])
Community ChampionCan you post that in text so that I can copy and paste easily into an Enter Data query?
Helper IHey!
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
- Greg_Deckler
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])
- dyingod
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:
