Forum Discussion
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:...
Anonymous I think I understand the question better now. Please try this:
Average = CALCULATE(AVERAGE('Table'[Column]),ALLEXCEPT('Table','Table'[Weeknr]))
jppv20
Solution Sage
Solution SageAnonymous Could you please provide some example data and the desired output? I'm not sure if I understand your question.
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
Anonymous I think I understand the question better now. Please try this:
Average = CALCULATE(AVERAGE('Table'[Column]),ALLEXCEPT('Table','Table'[Weeknr]))