Showing results for 
Search instead for 
Did you mean: 

Build average in Calculated Column

Former Member
0 Kudos


I have 3 restricted columns which contain the sum of sales quantity per week and what I want to do is to create the average of these 3 weeks. Is it not possible to build first the sum of the 3 restricted columns and then divide by 3?

Thanks & Best regards


Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Feel free to add details of your model and restricted measures and I can try helping with your use case.

In general though the only to do average calculations, as far as I've ever seen, as to either add a generated column or a calculated column (calculate before aggregation) with value of 1.0

Then a final calculated column (calculate *after* aggregation) which divides your measure by the column defined above as value 1.

You'll effectively get an average by doing this.