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])
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])