How to calculate YTD Average based on a selected date.

[Mavericks334]

Hi

I have the below DAX measure,

=calculate([Value_Corrected1],datesbetween(Dates[Date],Year_Period[Selected_Year_Start_Date],Year_Period[Selected_Month_End_Date]))

That is giving me the sum of headcount for the dates that i select. However i need to get the average of the headcount for the period selected.

Any idea how it oculd be calculated.

Regards,
Renato.

 

[Mavericks334]

I created an additional measure, which is

=calculate([Value_Corrected1],datesbetween(Dates[Date],Year_Period[Selected_Year_Month_Start_Date],Year_Period[Selected_Month_End_Date]))/[Selected_Fiscal_Period]

Where [Selected_Fiscal_Period] = Max[Fiscal_Period].

I am able to get the average like this.