How to calculate Experience of a person as each month changes using a slicer

[Mavericks334]

Hi

I have two table, one is the joining date table and Month-end table. I am trying to create a measure that would give me the experience of the person, when i use the month end table as a slicer and does not work.

Measure: Monthend[Month_End_Date]-Tenure[Joining_Date].

It does not work. I have also created a relationship between both these tables.

Any suggestions what changes i could make to get it to work.

Regards,
Renato.

 

[Mavericks334]

=(if(countrows(values(MA_Dates[Month_End_Date]))=1,
     if(values(MA_Dates[Month_End_Date])<=LASTDATE('Employee Details'[Joining_Month_End])
 &&values(MA_Dates[Month_End_Date])>=dateadd(lastdate('Employee Details'[Joining_Month_End]),(max(Period[Period])*-1),month),calculate(DATESBETWEEN('Employee Details'[Joining_Month_End],dateadd(lastdate(MA_Dates[Next_Month_Start_Date]),-1,MONTH),lastdate(values(MA_Dates[Month_End_Date]))))*-1)))*-1

This is the code i tried by creating an additional table called MA_Dates i get blanks

 

[Mavericks334]

Hi,

I Found partial solution for the experience.

=(CALCULATE((MAX('SharePoint Data'[Month_End])-MAX('Employee Details'[Joining_Month_End])),USERELATIONSHIP('Employee Details'[Employee Name],'SharePoint Data'[Reviewer])))/360.

=CALCULATE((YEARFRAC(MAx('Employee Details'[Joining_Month_End]),MAx('SharePoint Data'[Month_End]),1)),USERELATIONSHIP('Employee Details'[Employee Name],'SharePoint Data'[Reviewer]))

I have tired both the measures and for few employees who joined in 2001. I should get an experince of 11 yrs i get experience of 101. Which is incorrect.

Any Suggestions, what changes i could make.

Regards,
Renato.