Forum Discussion
Count New Hire Per Month
Hi, I have a table of Headcount that has below fileds and I need to count the new hired per month: Table = Headcount Fields = Report Effective Date (which is the monthly report date, that change...
Hi,
I recently came across the same issue. Here is the solution I used in my report:
New Hires by Period = CALCULATE(COUNTROWS(<Data source>),
FILTER(VALUES([Hire Date]), [Hire Date] <= MAX(Dates[Date])),
FILTER(VALUES([Hire Date]), [Hire Date] >=MIN(Dates[Date])))
Let me know if it worked.