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

ryan_mayu's avatar
ryan_mayu
Super User
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks , this worked

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      3 years ago

      you are welcome