Forum Discussion

dyingod's avatar
dyingod
Icon for Helper I rankHelper I
9 years ago
Solved

AdWords avg. position calculation

Hello,   Super newbie here... so this might be a really easy one.   Regardless of whether or not you know AdWords, to calculate Average position in Excel, one can just do the following formula: ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    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's avatar
dyingod
Icon for Helper I rankHelper I
9 years ago

Hey smoupre! Thanks for answering the call!

 

What sort of data do you need? Here is a screenshot of the table I am trying to plug this as a Mesure:

 

If you need anything else let me know! More than happy to supply! 

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

Can you post that in text so that I can copy and paste easily into an Enter Data query?

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      9 years ago

      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's avatar
        dyingod
        Icon for Helper I rankHelper I
        9 years ago

        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: