Forum Discussion
Active Employees HR headcount dashboard
Hello, I am trying to calculate the active employee's in the company between the dates i put in my date filter. I've got a master date table that I am using in the date filter. Below is the measu...
Hi Anonymous
If active employees refer to the ones who are working for this company between selected date the period.
For example, if i select date 2018/7/1~2019/4/17, then active employees should be hired before or at 2018/7/1, leave after 2019/4/17.
If my assumption is the same as your scenario,
Please create such relationship
create such measure
Measure = CALCULATE(COUNT('code table'[code]),FILTER(Sheet4,Sheet4[hired]<=MIN('calendar'[Date])&&Sheet4[leaving]>MAX('calendar'[Date])))Best Regards
Maggie
v-juanli-msft
Community Support
Community SupportHi Anonymous
If active employees refer to the ones who are working for this company between selected date the period.
For example, if i select date 2018/7/1~2019/4/17, then active employees should be hired before or at 2018/7/1, leave after 2019/4/17.
If my assumption is the same as your scenario,
Please create such relationship
create such measure
Measure = CALCULATE(COUNT('code table'[code]),FILTER(Sheet4,Sheet4[hired]<=MIN('calendar'[Date])&&Sheet4[leaving]>MAX('calendar'[Date])))
Best Regards
Maggie