Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    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))
v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous 

 

I agree with  Greg_Deckler .You need to rely on a date column to calculate the cumulative. If you still need support, please upload some insensitive data samples and expected output, so we can help you soon.

 

Best Regards,

Community Support Team _ Janey