Calculate Average employee Quarterly


I have my calculations for Average Monthly Employees as follows

Total  Employee = CALCULATE(SUM(Employee[Total Employee ]),LASTDATE('Date'[Date]))

Total employee previous month = CALCULATE([Total Employee],DATEADD('Date'[Date],-1,MONTH))

Average monthly Employee = IF([Total employee previous month]=0,[Total Employee],
    [Total Employee]+[Total employee previous month])/2

But what we need for Average Quarterly Employee is

(Employee[Total Employee Month 1]+ Employee[Total Employee Month 2]+Employee[Total Employee Month 3])/3

Please advise


Hi @Marta,

Probably, what you need is to change your Time Intelligence Function. There are quaterly Functions that can help you do this.

Try go through this course:

Let me know if this helps you.

Best regards,

Jorge Galindo