Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculating average on year

Hi all,   as my subject seems very easy to solve, I don't succeed in this. I found already similar topics on this forum and used the formulas mentioned there, but it still doesn't give me the resul...
  • sjoerdvn's avatar
    sjoerdvn
    2 years ago

    Did you add "avg prm" as a computed column instead of a measure? 

nirali_arora's avatar
nirali_arora
Icon for Resolver II rankResolver II
3 years ago

You might require the following measures-

Avg of sum = Calculate (averageX(values(Purchases_All[Year]) , calculate(Sum(Purchases_All[Quantity]))), all( Purchases_All[Year]))

 

Avg of sum = Calculate (averageX(values(Purchases_All[Month Year]) , calculate(Sum(Purchases_All[Quantity]))), allexcept(Purchases_All, Purchases_All[Year]))