Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Average Headcount Measure for Fiscal Year

Hi,    I'm getting a totally different figure below for my Average Headcount for Fiscal Year 23, can someone please check my measure below and correct where I've gone wrong. My page has a Fiscal Ye...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    The below measure works and brings my average headcount to 10766 which matches the Excel calculation in my screen shot.

    Avg. Headcount FY = AVERAGEX(VALUES(DimDates[Month & Year]),[Headcount])

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , Try like

 

Avg. Headcount FY =
VAR v_fydates = DATESINPERIOD(DimDates[Date], MAX(DimDates[Date]),12,MONTH)
RETURN
calculate(AVERAGEX(Values(DimDates[Month Year]), [Headcount]),v_fydates)

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi amitchandak 

 

I've appplied the above measure but the figure is comming up to 11112, any other ways to do this?