Forum Discussion

MStark's avatar
MStark
Icon for Helper III rankHelper III
3 years ago
Solved

Average Active EEs for Date Range

Hi,   I have a tableof employees with Hire, Termination and Rehire Dates. I also have a date table Im trying to get the average amount of active employees for whatever date range is selected on th...
Need Help
  • MStark's avatar
    MStark
    3 years ago

    I created the measure below and it works for now! Thanks so much for all your help!!

     

MStark's avatar
MStark
Icon for Helper III rankHelper III
3 years ago

Greg_Deckler Employee # stays the same but an additional row is not added. Theres a separate column named Rehire Date (see sample data on original post)

I was thinking of adding 2 more Var for Rehires on first day selected and rehires on last day selected. Then to add it to the average. Did something like this but its not working. Think maybe the issue is that its counting employees who dont have a rehire date instead of only rehires <= Max or Min dates

Any advise on what Im doing wrong or a different way to get this done?

 

Thanks for taking the time to look into this!

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

MStark Maybe tank your __RF and __RL variables and in your __F and __L variables where you refer to [Hire Date] replace that column reference with MAX([Hire Date, [Rehire Date])

  • MStark's avatar
    MStark
    Icon for Helper III rankHelper III
    3 years ago

    I created the measure below and it works for now! Thanks so much for all your help!!