Forum Discussion
Employees headcount
Anonymous , can you share the formula you used. Do these dates have a timestamp. hire number seems off by far at few places.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hello, I have basically 3 tables, Calendar Table in which i have dates from 1/1/2019 to 12/31/2020 Timehseet table in which I have timesheet data, suppose I have 1000 employees and in a particular week only 800 employees have filled time sheet so it will have data for just 800 emplyee for latest week.
and last i have employee table in which i have all employee information, date of joining and date of termination
i made an active relation with calender's date to timesheet date
and another active relation of timesheet employee id with employee's table employee id
and 2 inactive relation of emplyee and calendar table on start date and end date with calendar date
and i am using these measures