Register
Log In
Unanswered
Home
Power Query
Power Pivot
Power BI
February 24, 2017
Offline
Hi everyone
I've attached a table with employee data (which I've included in a PPVT Model):
*Start Date
*Termination Date
I'm only interested in the number of employees (Head Count) in 2017.
Thus, I need to identify the following (By month for 2017)
-number of starters (in 2017)
-number of leavers (in 2017)
-number of current employees.
Can you assist me with the formula to calculate these 3 metrics that I can track the Head count on a monthly basis, please? The challenge is that the current number needs to be dynamic, as this needs to change every month when the employee data updates.
Thank you
July 16, 2010
Offline
Hi Eduard,
The file attached didn't have a Power Pivot model. Were you hoping to do this calculation in a PivotTable? I ask because you mention using formulas.
Mynda
Power Query
Power Pivot
Power BI
February 24, 2017
Offline
Hi Mynda
Yes, the table that I attached is one of the source tables in my Power Pivot model, which I'm developing for an HR department's monthly reports.
Will it be easier to do the calculations in the Pivot table itself or in the source table? Either way, can you guide me with the correct or best formulas, please?
Thank you
Most Users Ever Online: 57
Currently Online:
12 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Md. Rahman
Lilian Vo
Jane Kumwenda
David Miller
Efe Onwochei
LynAnn Williams
Brandy Kriger
purna chandar
E K
velissa barr
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
