Calculate headcount question

[sam.mckay]

Hi there,

I have the exact solution for you in the tutorial below.

Total Number Of Staff Over Time - Power BI Insights

Also see here for some other solutions

How to calculate Headcount over time

Hi, I was trying to solve an issue in PowerBI, which I thought, should be an easy task. Unfortunately it isn´t - at least - not for me. After trying several approaches without any noticeable progress, I wanted to ask for your support, before it drives me crazy Here is the scenario: We have several Cost Centers in different locations. Each Cost Center has a Cost Center Lead and some Users Each employee (Lead and Users) have a defined Start and End Date Employees can change Cost Center…

Employee Headcount

Help please: I have been using the below formula for headcount - this appears to work correctly for top line number of colleagues - however when it is filtered down to team level it doesn’t give the correct headcount. I essentially need the exact number of employees who are with us on any given date. My headers on my data include: Date Joined Date Left Department Leaving code Description No of Colleagues = CALCULATE([Joining],FILTER(ALL(Dates[Date]),Dates[Date]<=AVERAGE(Dates[Date])))-CA…