Forum Discussion
Calculating Total Employees each Month
Hi All, Looking to create a measure which tells me which employees are present at a certain month and year. I have a "Persons" Table with the following fields: Full Name, First Name, Last Na...
Please see attached full shot of the measure.
I basically would like to get the figures below. So during December 2022 I had 179 Employees with a start date equal or less than 31/12/2022, and a leaving date equal or less than 31/12/2022 or blank. Then in Jan 2023 184. Etc etc.
johnt75
Super User
Super UserYou're missing the COUNTROWS from the CALCULATE statement