Forum Discussion

V_20's avatar
V_20
Frequent Visitor
2 years ago
Solved

Group Active Employees based on tenure

Hello Community,   I have the below requirement which i am unable to write a measure. Let me try to explain my data. I have a Fact table as shown below   Table has employee log and tnure at the t...
Need Help
Show and Tell
V_20's avatar
V_20
Frequent Visitor
2 years ago

Hi Ashish,

 

the 2,0,1 are the count of employees as of date with tenure months 1,2,3 respectively. 


A got terminated on 7th so as of 8 he is not active employee. He is not conisdered. 

B has tenure of 1 month as of 8th  

C has trnure of 3 months as of 8th

D has tenure of 1month as of 8th date. 

hence the table shows the result of 2 employees with 1 month tenure. 1 employee with 3 month tenure

 

if 8th date log is not there for a employee, we need to get the max date which is less than as of date to get the latest log of that employee. 

 

hope this explains. Kindly let me know if you need further explanation.  

thanks for your reply.