Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

formula to calculate weekly average

Good day,   Wonder if you could help with this,  I am trying to create a formula to create a weekly average on PowerBI (will be honest, am a bit new to it).  So the data i have is : WeekNum:...
Need Help
Tips and Tricks
  • jppv20's avatar
    jppv20
    4 years ago

    Anonymous I think I understand the question better now. Please try this:

    Average = CALCULATE(AVERAGE('Table'[Column]),ALLEXCEPT('Table','Table'[Weeknr]))
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for this jppv20 

so will this divide the total by the amount of distinct weeks?  
my worry is that it gives me the DividedBy result and not an average value


apologies if it is a stupid question

 

  • jppv20's avatar
    jppv20
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Anonymous Could you please provide some example data and the desired output? I'm not sure if I understand your question.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      so i want to calculate the average and not the division, if you look at my detail in the original post the dividedby value is different to the average 

      its a big dataset .

      but each ticket in the table has a DateTime column, and i derive the WeekNum from that. 
      So i want to determine average per week,  rather than divide total by amount of weeks?

      • jppv20's avatar
        jppv20
        Icon for Solution Sage rankSolution Sage
        4 years ago

        Anonymous I think I understand the question better now. Please try this:

        Average = CALCULATE(AVERAGE('Table'[Column]),ALLEXCEPT('Table','Table'[Weeknr]))