Forum Discussion
Headcount DAX Formula
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 thi...
Hello,
I am having this error
Cannot find the table 'Date'.
Thank you for your help
johnt75
Super User
Super UserChange '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.