Forum Discussion
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...
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])
Hi AjithPrasath
Thanks but this is giving me the same figure as Mar-23 11013 in my card visual, is there another way to write this so I can get the accurate figure for the 12 months in a fiscal year example provided in my screenshots?
Any help with this will be great for my development.
AjithPrasath
Resolver II
Resolver IIcan you try this
Avg. Headcount FY =
CALCULATE(
AVERAGE([Headcount]),
DATESINPERIOD(
DimDates[Date],
MAX(DimDates[Date]),
-12,
MONTH
)
)