cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stevemills04 Frequent Visitor
Frequent Visitor

Average Employee Count

Hi All! First time PBI user. I have a report that contains Employee Names, Unique ID, Hire Date, Termination Date and Status (Active, Terminated). My goal is to calculate monthly, quarterly and yearly average headcount. Internally, we calculate monthly headcount by taking the number of active employees on the 1st of the month, 15th of the month and last day of the month and dividing by 3. Then, the quarter and yearly are the sum of the monthly averages divided by the number of completed months. How do I go about calculating this in Power BI so that I can use a month/qtr/year slicer on my visuals? I don't know where to begin.
3 REPLIES 3
Super User IV
Super User IV

Re: Average Employee Count

Hi,

 

Share a dataset and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
stevemills04 Frequent Visitor
Frequent Visitor

Re: Average Employee Count

Ashish, thanks for the reply. Here are some screenshots of what I do in Excel and I am trying to translate it to Power BI. There are the exact files I am connecting to.

 

Screenshot of what I use to calculate average employees3y0jj7N

 

 

 

 

 

 

Screenshot of my Terminations ListszVGhf3

 

 

 

 

 

 

And finally, the summary page of my results as they appear in Excel (Would use a combo of tables and visuals in Power BI)pn9xmGY

 

 

Super User IV
Super User IV

Re: Average Employee Count

Hi,

 

I cannot understand anything from those screenshots.  I will need to see that Excel file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors