Forum Discussion
MStark
Helper III
Helper IIIAverage 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...
I created the measure below and it works for now! Thanks so much for all your help!!
Greg_Deckler
Community Champion
Community ChampionMStark 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])
MStarkHelper III
Helper IIII created the measure below and it works for now! Thanks so much for all your help!!