Build average in Calculated Column

[Former Member]

Hi,

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

Seyma

[Former Member]

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.