Forum Discussion
Calculate Cumulative headcount numbers
Hi there, need some assistance with calculating cumulative headcount. I have a data file with a starting headcount for the beginning of the year and then all year to date hires and leavers in separa...
Anonymous Why are you using TODAY? Where you have TODAY, this needs to be the termination date of your person.
Running Total Hires = VAR __Date = MAX(New_Hires[Effective Date]) RETURN COUNTROWS(FILTER(ALL(New_Hires),[Effective Date] <= __Date))
Thanks Greg_Deckler
i have attempted the formula suggested but doesnt seem to work for me as not splitting by the individual periods
Running Total Hires = VAR __Date = MAX(New_Hires[Effective Date]) RETURN COUNTROWS(FILTER(ALL(New_Hires),TODAY() <= __Date))
Do i need to insert another date in this formula where i have made the text bold?
Anonymous Why are you using TODAY? Where you have TODAY, this needs to be the termination date of your person.
Running Total Hires = VAR __Date = MAX(New_Hires[Effective Date]) RETURN COUNTROWS(FILTER(ALL(New_Hires),[Effective Date] <= __Date))thank you so much Greg_Deckler , this now works!!
muchos gracias