Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I am new to Power BI and need your precious help here.
My data is as follows:
My calendar is as follows:
What is the formula for headcount per month please?
I am trying this but it is not functioning..
Thank you so much for your assistance
Ariane
Try
Headcount =
VAR SelectedDate =
MAX ( 'Date'[Date] )
RETURN
CALCULATE (
DISTINCTCOUNT ( Employees[EmployeeID] ),
Employees[DateStart] <= SelectedDate
&& (
ISBLANK ( Employees[DateDeparture] )
|| Employees[DateDeparture] > SelectedDate
)
)
Hello,
I am having this error
Cannot find the table 'Date'.
Thank you for your help
Change 'Date'[Date] to 'Calendar'[Date]
It is still not good 😕
From my excel I have 182 employees in Dec 2022 but the headcount showing 229.
It is still taking employees who left in 2021
Looks like I found the mistake.
The departure date should have been put in all the months of the employees who left. I had included it only in the month they left.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |