Count number of employees

[Anonymous]

Hi, I would like to count the number of active employees in a given period. In the end we wannt to analyse if the company is    more productive (revenue divided by total hours or number of employees) after growing or before growing (they have gone from 9 employees to 19 employees mid 2019).

I have a facttable: FactHarvest which is a table where employees fill in their time registration, it looks like this:

Date - Hours - Client - Project - Task - Type - Name  Employee -  Billable - Billable rate - billable amount - Cost rate - Cost amount

And I have a dim table with all of the employees

Is there a way to count the  number of employees and get theem on a graph and see when the number of employees have grown?

[Anonymous · Accepted solution]

The solution to my problem was actually really simple in the end. I fixed part one with following formula 😅

EmployeeCount = CALCULATE(DISTINCTCOUNT(FactHarvest[NameEmployee]))

Part two after that step wass relative simple as well:

ProductivityIncomeHours = DIVIDE([totalIncome];[TotalHours])
ProductivityOutcomeHours = DIVIDE([TotalExpense];[TotalHours])

ProductivityIncomeEmployees = DIVIDE([totalIncome];[EmployeeCount])

ProductivityOutcomeEmployees = DIVIDE([TotalExpense];[EmployeeCount])

This resulted in this Graph:

Now need to figure out how I can get rid of the "false negative number" of employees count which is due to having an empty value on my months.

[Anonymous]

Hi everyone I refined my question, care to take a look? 

https://community.powerbi.com/t5/Desktop/Count-number-of-Employees-Productivity-Refined/td-p/960673

@Greg_Deckler @amitchandak @Mariusz 

[amitchandak]

Active employee refer my blog

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Appreciate your Kudos.

[Anonymous]

Thanks, is any of this possible without having start-end dates?

[Greg_Deckler]

@Anonymous  - Yes, I believe it is. Seems like what you need is to get a table that counts the number of employees on each day. Then you could get the maximum of that table. Seems possible. Hard to tell without sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

@Greg_Deckler  thanks for your answer, I have refined my question with soome Sample data, should I edit my question or make a new threat? It looks like this now:

Hi everyone, I have a question that consist of 2 parts. Part 1 is count active Employees over a given period. Part 2 is to check if the company is more productive with more/fewer employees.

PART 1

I would like to count the number of active employees in a given period.

I have a facttable: FactHarvest which is a table where employees fill in their time registration, it looks like this:

Date	Client	Project	Hours	Billable	Billable Rate	Billable Amount	Task	Type	NameEmployee
dinsdag 1 januari 2019	Data Wise	Cloud Architecture	8	No	86	688	Intern	Non-billable	Klaas Wouters
Woensdag 6 februari 2019	AbInbev	Customer interaction PoC	8	Yes	90	720	Billable Customer Time	Billable	Klaas Wouters
Vrijdag 1 maart 2019	Data Wise	Pyspark	8	Yes	90	720	Customer Time	Billable	Astrid Lemmens
Vrijdag 1 maart 2019	Data Wise	Pyspark	8	Yes	90	720	Billable Customer Time	Billable	Klaas Wouters

And I have a dim table with all of the employees, further there is no information in this table!

Name

Klaas Wouters

Astrid Lemmens

In the Sample data a new Employee has joined the company on vrijdag 1 maart 2019 (Astrid Lemmens). The end goal would be a (line)graph: X-Axis Month, Y-Axis number of Employees. The line graph should show the trend of employee growth/decline like this: 

PART 2

In the second part we want to check if the increase of Employees has a positive affect on Productivity. So we want to:

- Divide revenue by TotalHours worked or by Total Employees of that period

- Divide Costs by TotalHours worked or by Total Employees of that period

Herefor I have another Facttable used:  FactSilverfin which looks like this:

Line Item	Month	Value	True Value	Uitgave (Outcome)	Inkomsten (Income)	Monthname	Level
749000 Diverse bedrijfsopbrengsten	PTD 01/2019	-763,22	-763,22	-763,22	0	dinsdag 1 januari 2019	2
700000 Omzet	PTD 02/2019	2338	2338	0	2338	vrijdag 1 maart 2019	2
602102 Consultant 3	PTD 12/2019	8250	-8250	-8250	0	zondag 1 december 2019	2
612090 Restaurantkosten	PTD 11/2019	661,7	-661,7	-661,7	0	vrijdag 1 november 2019	2
700001Omzet 1	PTD 03/2019	9091,4	9091,4	0	9091,4	vrijdag 1 maart 2019	2

Thus what we want to do with these data is see how the number of Employees influences our revenue and costs.

Any ideas how to do this?

Thanks

[Mariusz]

Hi @Anonymous 

How would you know the period they were active in?

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Via the facttable, see my new post with more accurate data:

https://community.powerbi.com/t5/Desktop/Count-number-of-Employees-Productivity-Refined/td-p/960673

[Anonymous]

I don't need/want to know for each employee when they were active. I just need to know for example for 2019 at what moment there were more employees active.

[Greg_Deckler]

I think that seeing a representation of the data and not just column names would go a long way. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Mariusz]

Hi @Anonymous 

Sure you can use pattern in the attached file as long as you have employee start and end dates.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

I don't have any start-end dates.  Is it possible to calculate this without start and end dates?