Excel Forum

Headcount Calculation Measure Power Pivot

Deepak Gurung

New Member

Members

Forum Posts: 2

Member Since:
August 25, 2021

Offline

August 25, 2021 - 5:58 pm

Hi Mynda,

I have watched your HR dashboard videos in YouTube which was very exciting, I was looking for the similar report up to power pivot report only, to be honest.

You have calculated EMP count with EMP ID, HR Data, date. However, I have EMP ID, EMP Name, hired date and leaving date only.

So, how to measure the EMP count and Active staff month wise.

Regards,

Deepak

Mynda Treacy

Admin

Forum Posts: 4449

Member Since:
July 16, 2010

Offline

August 29, 2021 - 6:24 pm

Hi Deepak,

Please provide a small sample file that illustrates your data and desired result so we can help you further.

Mynda

Deepak Gurung

New Member

Members

Forum Posts: 2

Member Since:
August 25, 2021

Offline

September 6, 2021 - 10:06 pm

Hi Mynda,

Sample file attached, waiting for your kind assistance to correct the measures.

Deepak

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Kim Knox, Kevin Lenahan

Guest(s) 9

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 871

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

Jessica Stewart: 204

A.Maurizio: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

Kathryn Patton

Maria Conatser

Jefferson Granemann

Glen Coulthard

Nikki Fox

Rachele Dickie

Raj Mattoo

Mark Luke

terimeri dooriyan

Jack Aston

Forum Stats:

Groups: 3

Forums: 24

Topics: 6221

Posts: 27285

Member Stats:

Guest Posters: 49

Members: 31908

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen