Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Average Headcount Calculation

I need to calculate average headcount    Will need help in arrving at below number in power bi. My excel look this   Month Closing Headcount Avergae HC - Average function Oct 3585 3585 ...
Need Help
Show and Tell
Tips and Tricks
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    Anonymous 

    1. you need to have a date column or year month column

     

    2. you can create a column

    Column = AVERAGEX(FILTER('Table','Table'[year month]<=EARLIER('Table'[year month])),'Table'[Closing Headcount])

     

    or a measure

    Measure = AVERAGEX(FILTER(all('Table'),'Table'[year month]<=max('Table'[year month])),'Table'[Closing Headcount])

    pls see the attachment below

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Does the Financial Year run from October to September?  Also, share some data to work with (in a format that can be pasted in an MS Excel file.) or share the download link of your PBI file.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Yes we have fiscal year concept.

The solution worked which was provided on trail message.

 

Thanks!