Hi, I have a fact table which contains the motion of the Payroll, this table I have the month and year of the sheet and the date of termination of service, the problem is that when I have the terminations additional employees who were already turned off appears again indeed, what I want is that this functionary not tell when the withdrawal date is <than the month and year of the sheet.
Exemple:
Mat Month Year Off
1 1 2013 01/05/213
1 2 2013 01/05/213
1 3 2013 01/05/213
1 4 2013 01/05/213
1 5 2013 01/05/213
1 6 2013 01/05/213 1 6 2013 <== from here should not be counted in the expression
